Forum Discussion

MarioMazzoli's avatar
MarioMazzoli
Regular Visitor
7 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 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!

  • 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

1 Reply

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