Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi!
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:
Measure1
Measure2
Measure3
Also I have this dimTable:
Index Measure Name
1 Measure1
2 Measure2
3 Measure2
I need to create this waterfall who shows:
Measure1Name ---- Measure1
Measure2Name ---- Measure2
Measure3Name ---- Measure3
I have created Measure in SWITCH that says:
Solved! 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?
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
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?
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
thanks, I have realized I used to much selected switches. It was an issue with my model.
Glad to help!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
16 | |
8 | |
7 | |
7 | |
6 |
User | Count |
---|---|
23 | |
11 | |
10 | |
10 | |
8 |