Forum Discussion
Waterfall with custom categories and SWITCH
Hi DagmaraG , I was able to get something to work by doing the following:
3 Measures: Measure 1, Measure 2, Measure 3. Note that these are each DAX measure in the main table:
Measure 1 = [Measure] +1Measure 2 = [Measure] +2Measure 3 = [Measure] +3I then created a parameter, in an unlinked table isolate, with the values 1,2,3 and corresponding switch statement. This returns expected results when tested in a straight table
I can then add these values into a waterfall chart, and the results are as expected.
What are you doing differently? Are the tables connected - they should not be connected. Perhaps if this does not work you can share a screenshot of the model?
Pi
PS, if you want even more flexibility around waterfall charts, I have a blog on how to create from bar chart: https://www.iheartdemography.com/post/hacking-a-waterfall-chart-in-powerbi
Resolver IIHi DagmaraG , I was able to get something to work by doing the following:
3 Measures: Measure 1, Measure 2, Measure 3. Note that these are each DAX measure in the main table:
I then created a parameter, in an unlinked table isolate, with the values 1,2,3 and corresponding switch statement. This returns expected results when tested in a straight table
I can then add these values into a waterfall chart, and the results are as expected.
What are you doing differently? Are the tables connected - they should not be connected. Perhaps if this does not work you can share a screenshot of the model?
Pi
PS, if you want even more flexibility around waterfall charts, I have a blog on how to create from bar chart: https://www.iheartdemography.com/post/hacking-a-waterfall-chart-in-powerbi
