Forum Discussion
Bridge/Waterfall chart with multiple values
Hello, I've seen some similar posts but not one that exactly addresses this issue I have, I need to replicate this graph: The graph shows some financial values (concepts) ordered by an ...
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!
Anonymous , First of all get the values in a single column using DAX such as:
Value 3 = SWITCH(TRUE(),
Table1[ID] IN {1,5}, Table1[Value 1 ],
Table1[ID] IN {2,3,4}, Table1[Value 2]
)
Table1[ID] IN {1,5}, Table1[Value 1 ],
Table1[ID] IN {2,3,4}, Table1[Value 2]
)
Then use this column in the stacked bar chart/ waterfall chart / any chart of your choice.