Forum Discussion
Custom Sort on a Matrix Help Pleaseeee!!!!!!
Of course!!! I created Index colum after unpivotting other columns; that create an idex for every single record. So i went back to PQ and created index then unpivot columns, and that worked as expected.
Thank you so muchhhhhh!
You need to create an index column, just on the field Descripton-Owner
401 Kathy => 1
401 - Credit Kathy => 2
then add a custom sort to your column on the new index
then sort in the matrix on the description column
That doesn't work! I have tried already with an index. The data is unpivotted, so the are multiple values in the table for each sort item (index number).
Thank you for replying ,; )
You have to model your data in a way, you have it as unique.
In powerquery you could use reference, and then remove the duplicates.You can then link both tables in power bi relations, or create the link in power query
Of course!!! I created Index colum after unpivotting other columns; that create an idex for every single record. So i went back to PQ and created index then unpivot columns, and that worked as expected.
Thank you so muchhhhhh!