Waterfall chart changes between two years

[zervino]

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.

[Anonymous · Accepted 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.