Forum Discussion
Hiding A Sorting Row in A Matrix
Please help me with my Matrix. I have a matrix I created so that users can drill down to lower levels to see what values live underneath them. The problem I am having is that I want to sort b...
Hi Anonymous
Please select the column you want to sort first.Then click sort by column.Attached the sample file for reference.
Regards,
Cherie
Hi Anonymous , its actually quite a simple process to do what you need. It's just difficult to describe in words. I've made a little video for you. The trick is sorting the AccountSubGroup field by the LEVEL field (make sure your Level field is already sorted in ascending order). Here you go:
How to sort a matrix by a "hidden" field: https://youtu.be/n7VYW-vfCrY
Hi michellepace
And what do you about ordering a table of financial statements, when you have repeated classifications because of the comparison year?, like this case. Power BI doesnt let me sort by [Índice] because of the repeated rows.