Forum Discussion
Variable Y axis scale based on slicer?
Hi. I ama relatively new user....Is there a way to set the Y axis scale of a bar/line chart, based on a slicer choice? I have widely varying data maximums based on a slicer. I could leave the scale auto but I need my bar and line to use the same axis values (for example a data bar and a target line). Is there a way to set the scales to be the same AND vary by slicer?
I hope this is a good enough description. A solution for either aspect would be appreciated..Thanks!
@crawfe , there is no option to set the Y-axis scale by a measure or variable. Automatic is just an option that can reset the scale based on changes
5 Replies
- amitchandak
Super User
@crawfe , there is no option to set the Y-axis scale by a measure or variable. Automatic is just an option that can reset the scale based on changes
I didn't find a way to explicitly set the Y and Y2 axes to sync, but I found that if I turn off Secondary axis (and title) and set the Y2 axis scale to auto-auto (Both needed!), and the Y axis to 0-Auto, the Y2 axis seems to track the Y axis. So this gets me past the slicer big difference problem. Thanks for giving it thought!
- mahoneypat
Microsoft Employee
You could use the value of a slicer in a measure where you divide your original result by the slicer value and turn your Y axis into % of slicer value. If you then fix the Y axis to a max of 1, you would get a zoom in effect with slicer changes.
Regards,
Pat
