Forum Discussion
Bridge/Waterfall chart with multiple values
At the end I did this:
I used a stacked column chart, with 2 created columns and the value2 column, the first created column had value1 for Concept A and D and 0 for the rest and the second created column with Value 1 for concepts B, C and D and 0 for the rest.
What I did was, put the first created column (both blue bars in the image) and the others aren't shown because they have 0 as value, then the second created column with color white (so they aren't shown) and then the value2 column on top to replicate it exactly. Thanks to everyone who helped!
Create a mesure with logic : if value2 is 0 then show Value1 else Value2. use this measure in Waterfall chart.
if it is difference comaprate to prevoius month , you can use above logic to build difference(salesamount -SalesAmountPM) and plot waterfall chart with Month and differnce.