Forum Discussion
Help with measure that shows difference between two consecutive bars
Hi,
I have the below bar chart and I want to include other bars in between which shows the difference between the values of two consecutive bars. For example, grey colored bars between each Orange colored bar showing the difference for the two bars.
How shall I create a measure for that when all the brands in below example are in the same column 'Brands" in data without changing the layout of Brands in data.
Thanks for your help!
4 Replies
Anonymous it is not clear what you are comparing and what would be the variance?
Thanks for the reply!
I am looking to add another measure in between each orange bars. This measure should show the difference between the two orange bars. For example, Brand 3 is 33% and Brand 2 is 59.5%. So, the new measure will be 33 - 59.5 = -26.5. So, the new measure will be represented as a gray colored bars in between each orange colored bars. The value for grey colored bar between brand 2 and brand 3 will be -26.5%. Similarly, the value for grey colored bar between brand 1 and brand 2 will be 45.2% (59.5 - 14.3).
Something like below chart, where light grey bars (highlighted with yellow arrows) shows the values for the new measure that I want to create. In my case its straight difference bwteen the two bars in Dark Blue colors
Example
Thanks for your help!
