Forum Discussion
Helper IFlexible matrix sorting
In PowerBI set this field in your country table on the "Customer Country" column to your "Customer Country Index".
When you put Customer Country on your Matrix and below columns from other connected tables, then afterwards sort your matrix by"Customer Country". And PowerBI automatically uses the Index to sort it, even if you don't put it there.
You can also send me a message, if you are still stuck and want to write about it in German 😉
BR
Helper IYeah but I dont understand where to but the index. If I put it in the rows it will become a hierarchy and I dont know how to hide that. This doesnt hide. And its a matrix not a normal table..
lukiz84Memorable Member
You don't need to put it on the matrix. PowerBI uses it internally, when sorting the "Customer Country" field.
BR
- MarlenePirker
My matrix is consiting of data from 3 different tables connected by relationships. I dont really get what table I should sort here and how this would change my matrix. I am sorry but I dont understand what you mean 🙂
- lukiz84
In PowerBI set this field in your country table on the "Customer Country" column to your "Customer Country Index".
When you put Customer Country on your Matrix and below columns from other connected tables, then afterwards sort your matrix by"Customer Country". And PowerBI automatically uses the Index to sort it, even if you don't put it there.
You can also send me a message, if you are still stuck and want to write about it in German 😉
BR