Forum Discussion
MarioMazzoli
8 years agoRegular Visitor
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...
- 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
Anonymous
7 years agoNot 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