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!
Anonymous , First of all get the values in a single column using DAX such as:
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.
Anonymous Hello, what graph is that? Because whenever I use a waterfall chart there is a total column that shows automatically and I don't know how to hide it.
And I have to wonder, do you know how to make it appear exactly as the image I showed you? Because in this one the bars always start where the last bar finished, is there a way to make it like I showed?
TIA
We can't hide total bar in waterfall chart .
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!