Forum Discussion

romovaro's avatar
romovaro
Responsive Resident
4 years ago
Solved

Waterfall Graph Current vs Previous week

Hello   Quick question regarding Waterfall Charts.  I have a table like the one below. It's data that i get from different sources and it's added manually. I have created a power Bi report and I w...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  romovaro ,

    Here are the steps you can follow:

    1. Go to Power query, select all the columns of the table, and click Transform – Unpivot Columns..

    Result:

    2. Add Column – Index Column From 1.

    3. Click [Attribute] – Column tools – Sort by column – [Index].

    4. Click the ellipsis – Sort axis – Attribute – Sort ascending.

    5. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly