Forum Discussion
Waterfall from columns
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!
- Anonymous7 years ago
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
1 Reply
- AnonymousNot applicable
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