Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a question regarding the scaling of the axis in bar charts. I am trying to visualize a butterfly chart with a bar chart.
I have 2 measures, but the amount of measure 1 is much higher then measure 2, this results in a wrong scale for the 'negative' values. Is it possible to change scale in the same visual for measure 2. so for the negative values not in steps of 100k but in 10 or 50?
See example below:
hopefully someone has a solution for this.
There aren't a lot of options to have different scales. You can force it to look right by doing the expression for measure 2 to be something like =Sum(100*[measure])
But then to avoid confusion you will need to add a note, perhaps in the title, like "Negative values x100 for clarity"