Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 Orang...
Need Help
Tutorial Requests
parry2k's avatar
parry2k
Super User
5 years ago

Anonymous it is not clear what you are comparing and what would be the variance?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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!