Forum Discussion

MarioMazzoli's avatar
MarioMazzoli
Regular Visitor
8 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    7 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