Forum Discussion

Seigfried's avatar
Seigfried
New Member
8 years ago
Solved

Creating waterfall charts

Hi All, I am new to PowerBI and have a (rookie) question. I am trying to create a waterfall as per this tutorial. The problem I am facing is that my excel data contains months as column header....
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Seigfried,

     

    You need to unpivot your columns to have an attribute column (date) and other with values.

     

    Without further information can't help you more than this,

     

    Regards,

    MFelix

Omega's avatar
Omega
Impactful Individual
8 years ago

Can you please share a screenshot of the data? I believe what you are trying to do is transpose the months such that they become one column, and your KPIs (like sales) to become your measures. 

Seigfried's avatar
Seigfried
New Member
8 years ago

correct.