Forum Discussion
Waterfall chart changes between two years
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.
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.
1 Reply
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.