Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have information in this format:
Year | Department | Sales |
2022 | Accessories | 1200 |
2022 | Services | 500 |
2022 | Core | 4200 |
2023 | Accessories | 800 |
2023 | Services | 700 |
2023 | Core | 3800 |
I want to create a waterfall chart that shows the evolution from 2022 to 2023 by department.
This is, first column would be the total for 2022 and then a waterfall (increase/decrease) by department (so 3 columns) and lastly a 2023 total column.
I see examples that make the waterfall by months, but I need by deparments instead, so not sure how to do it.
Solved! Go to Solution.
Hi, @zervino
Based on your information, I create a table:
Then follow this steps:
Create a waterfall visual, and put parameters in the field like this
The first column is the total for 2022 and then a waterfall (increase/decrease) by department and lastly a 2023 total column
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @zervino
Based on your information, I create a table:
Then follow this steps:
Create a waterfall visual, and put parameters in the field like this
The first column is the total for 2022 and then a waterfall (increase/decrease) by department and lastly a 2023 total column
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
139 | |
70 | |
67 | |
52 | |
52 |
User | Count |
---|---|
210 | |
92 | |
64 | |
59 | |
56 |