Forum Discussion
Solved
Custom Sort Attribute row in unpivot matrix
I created a matrix and below is the format Attributes 8/1/2021 8/2/2021 8/3/2021 8/4/2021 8/5/2021 A 234 234 23 23 689 B 45 345 234 234 689 C 3 345 234 234 689 ...
Hi therenjithr ,
Here are the steps you can follow：
You can sort according to the customization of Power query.
1. Enter Power query through Transform data, select Add Column – Column From Examples – From All Columns.
2. Enter Index123 corresponding to ABC in the column next to it.
3. Select column [Attribute], Column tools – Sort by column – column [Custom].
4. Select Sort ascending in the column [Custom].
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
I do not had to do step 2, but I used merge query to add mapped column from related table in actual table then followed ur steps on sorting, did the trick. Thanks for your effort.