Forum Discussion
Hiding A Sorting Row in A Matrix
Hi Anonymous
Please select the column you want to sort first.Then click sort by column.Attached the sample file for reference.
Regards,
Cherie
None of these suggestions work.
After much research by my boss and I, we are going to have Microsoft get involved and tell us how to make this work.
I simply want to sort by a hidden column in a Matrix. I should be able to add a column field to the Matrix, or a query, or a Dax created field, and sort it, then somehow hide it.
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
Thanks for the youtube video. Without it I wouldnt have got this working, I didnt realise you had to order the specific column by the column you want to sort by (I can see why describing it is difficult).
Anyway thanks :)
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.
