Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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):
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:
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!
Solved! Go to 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
@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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |