Forum Discussion
Matrix visual with calculation group: sort columns by measure first and by calculation item second
Hello!
I have a matrix visual with a calculation groups and several measures like this:
However, I would like to have the columns sorted by measure first, and then by calculation item, like this:
Is this possible, and if so, how? I don't need tips on how to disguise that it's two visuals like in the mock-up, I would prefer to indeed do it in one matrix.
Thanks for your input!
2 Replies
- AnonymousNot applicable
Hi Anonymous ,
Based on the description, try to create the new column to sort the measure and sort by column.
You can view the following links to learn more information.
Solved: Sort By Column changes the Measure results - Microsoft Fabric Community
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Thank you for your reply, but based on my understanding of the links provided, this is not what I am looking for. I know how to change the order of the measures or the calculation items. I want to switch around the hierarchy between these two ordering levels.