Forum Discussion
Waterfall Graph Current vs Previous week
- Anonymous4 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
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
- romovaro4 years agoResponsive Resident
Awesome. Thanks for the explanation step by step :). it worked