Waterfall from columns

[MarioMazzoli]

Hi,

I'm pretty new to PowerBI in general and to Waterfall charts in particular, so sorry for this maybe "basic" question.

I have a table with the following columns (among the others):

• Compilation Month
• Country
• Delta A
• Delta B
• Delta C
• Delta D

I would like to make a waterfall charts showing the Delta A, B, C, and D (sum of all countries and filtered for only one compilation month), just like this:

I managed to do this only by creating a separate table in Excel (and then imported in PowerBI) where using sumifs I have many lines with:

• Compilation Month, Country, Delta A, value
• Compilation Month, Country, Delta B, value
• Compilation Month, Country, Delta C, value
• Compilation Month, Country, Delta D, value

And then using "value" for my waterfall as Y axis and the column with Delta A/B/C/D as Category.

I expect there is a more elegant solution in PowerBI, can you help me?

Thanks in advance!

[v-yuezhe-msft · Accepted solution]

@MarioMazzoli,

You don't need to  create a separate table in Excel using sumif.

Directly import your original table to Power BI, then in Query Editor of Power BI Desktop, select  Delta A, B, C, and D columns, and unpivot columns. This way, you should be able to create expected Waterfall chart .



Regards,
Lydia