Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I hope you might be able to help me out here.
I have a bar chart with a slicer (2 options) and the same x axis. Is it possible to make a fixed y axis interval for each of the two options (in the slicer)?
To explain why I need the above: I have two bar charts - one for "Product 1" and one for "Product 2". In both, I have an x axis representing my time dimension, a y axis representing the sales, and a slicer in which I can choose between 1) Total Sales YTD and 2) Sales.
My "Product 1" has a lot higher sales than my "Product 2", but I would like to show the sales on the same scale (1:1), to visualize the inequality in performance. To do so, I have set a fixed interval on both charts (between 0 and 1,000,000) which works great for the first slicer option (Total sales YTD), but for the second slicer option (sales) the interval is too big and should instead be between 0 and 100,000, as sales per month does not get higher. For that reason, it would be fantastic, if it was possible to have a "fixed interval" that is dynamic relative to the slicre options.
Best regards,
Michael
@MRJ , There is a dynamic option to change y-axis range based on a slicer measure. Do not give y-axis start and end value, that is better. Or use bookmark and show two different visuals
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |