Forum Discussion
Helper IIIStacked Bar Waterfall - problems with Measures and Calculated Columns
Resident Rockstardo you need have the employees as legend?
Helper IIINo Sturla...not necessarily. However I would want to be able to use Type as a legend.
Thanks for the time you are taking on this...much appreciated
Gerald
- sturlaws
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
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:
- ghdunn