Thanks for all the help in previous posts. I have one more issue that is bugging me 🙂
I need to create WATERFALL chart but MEASURE in Y axis need to show different measures based on Category.
I have this Measures set:Measure1Measure2Measure3Also I have this dimTable:Index Measure Name1 Measure1 2 Measure23 Measure2I need to create this waterfall who shows:Measure1Name ---- Measure1Measure2Name ---- Measure2
Measure3Name ---- Measure3
I have created Measure in SWITCH that says:
Go to Solution.
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:
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?
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
View solution in original post
thanks, I have realized I used to much selected switches. It was an issue with my model.
Glad to help!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.