Forum Discussion
JimmyCeron_PBI1
5 years agoFrequent Visitor
Custom Sort on a Matrix Help Pleaseeee!!!!!!
After having tried so many different things and failing, I decided to reach out to this incredible community. I have a Matrix that need to be displayed in a specifc sort. I know how I can accomplish...
- 5 years ago
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!
Wimverh
5 years agoResolver IV
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
JimmyCeron_PBI1
5 years agoFrequent Visitor
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!