Matrix visual with calculation group: sort columns by measure first and by calculation item second

[Anonymous]

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!

[Anonymous]

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

https://blog.crossjoin.co.uk/2015/12/15/power-bi-desktop-sort-by-column-and-dax-calculations-that-use-the-all-function/

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.

[Anonymous]

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.