Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |