Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Miranda Garmon]

I am building a report that looks better if I add in a start and end to the scale on my Y Axis. However, when I up a filter on the values don’t show up. Is there a way my scales will transform with my filers other than the auto filter?

With Scales:

Without Scales:

 

[William Skelley]

Hi Miranda:

You should be able to set your Y axis and still filter. I used line and cluster column chart or bar chart. You also have the ability to add a second Y axis (see to bottom right of attached image). If you pick these chart styles they filter with your new axis. I guess you want to make sure you are picking these types of charts top right in visual’s pane. You can see this on my trend page. After you look please delete the file if you don’t mind.

Thank you,

Bill S

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————
——————————————-

[Miranda Garmon]

Thanks William, Have you done it using drill down?

 

——Original Message——

Hi Miranda:

You should be able to set your Y axis and still filter. I used line and cluster column chart or bar chart. You also have the ability to add a second Y axis (see to bottom right of attached image). If you pick these chart styles they filter with your new axis. I guess you want to make sure you are picking these types of charts top right in visual’s pane. You can see this on my trend page. After you look please delete the file if you don’t mind.

Thank you,

Bill S

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————

[William Skelley]

Hi Miranda:

I did it by using clustered line and column chart putting different measures in each field well. I didn’t use drill down in my example I just clicked on a bar value and it cross-filtered. This type of chart allows for a second Y axis(I did not use in my example).

I am happy to look at your file and see if you want to do that. I can look at it later in the afternoon if you want.

Thank you,

Bill

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————
——————————————-