Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I want to create a visual similar to the one below, but I need help figuring out how to structure the data so it can be visualized like the example below.
My data sources consist of current and previous month headcount rosters, terminations and hires list, as well as other lists of headcount additions. My initial was to create measures to aggregate each of the figures I wanted to represent on the chart and then add them to the waterfall visual but this simply didn't work since the waterfall visual only takes one field for the y-axis.
I appreciate any ideas on how to structure the data so it's compatible with the waterfall visual or ay other approaches that might get me the same result.
Solved! Go to Solution.
Try the Simple Waterfall visual. The Values field well allows multiple measures.
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000195?tab=Overview
Proud to be a Super User!
Try the Simple Waterfall visual. The Values field well allows multiple measures.
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000195?tab=Overview
Proud to be a Super User!
Great suggestion! It appears to do exactly what I need
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 28 | |
| 23 | |
| 18 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 47 | |
| 44 | |
| 43 | |
| 34 | |
| 30 |