Forum Discussion
MarlenePirker
Helper I
Helper IFlexible matrix sorting
Hello! I created a matrix and now want to sort the countries like in the image. I already created a index but I dont understand how to sort the matrix using the index and then hide the index col...
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
lukiz84
Memorable Member
Memorable MemberHi,
in your Table set the "SortByColumn" to the "Customer Country Index" field
BR