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.