Forum Discussion

ghdunn's avatar
ghdunn
Icon for Helper III rankHelper III
6 years ago

Stacked Bar Waterfall - problems with Measures and Calculated Columns

I would like to create a Stacked Bar Waterfall.   I can spoof a simple version in this way: Month Name Hard Coded Count 1 Jan Bob 1 1 Jan Fred 1 1 Jan Mary 1 4 Feb Bob 1 4 ...
Need Help
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

So, here is a draft: pbix

 

I have added data for march as well. In power query a new table is generated, so that the values that goes on the x-axis is dynamically handled.

 

And the measure is dynamic as well. The DAX of the measure might look a bit scary, but it is not very complex DAX. 

ghdunn's avatar
ghdunn
Icon for Helper III rankHelper III
6 years ago

Sturla,

 

Many thanks.  Could I just clarify, though that we are on the same page.

 

One of the major issues I am trying to deal with is to make the chart look like a waterfall chart, to show changes one month to the next.

 

So...if the first month has say, 5 people, and the 2nd month has two people added, then the chart would look as follows: