Forum Discussion
Solved
Sort rows with duplicated values in matrix
My task is to concatenate tables from different excel files into one big csv file, then recreate those tables in Power BI Matrix with different slicers. However, rows in each table must preserve its ...
WishAskedSooner
Continued Contributor
Continued Contributorsamrere ,
I feel your frustration because I was in the same place as you not too long ago.
IMHO, this is one of the BIG failings of PowerBI because the way it handles sorting is not well documented AND buggy. Therefore, it really should be a sticky HOW TO at the top of this forum, so everyone can be aware of these issues and the workaround(s) needed.
I have made a solution to this problem a while ago. You can handle sorting duplicative data either using Calulated Columns in DAX or PowerQuery. There are pros and cons to each method especially when using DAX. My preference is PQ, and knowledge is power which is why this forum needs a sticky.