Sort each level in Matrix differently

[vickyd]

In a Power BI Matrix that has multiple levels (Row Headers) displayed in a stepped layout form is it possible to sort first level say alphabetically or by default sort order and then the 2 level by total amount? 

In the screenshot below, the 1st level header values need to be sorted by their default sort as setup in the model using the sort by another column option but the 2nd level should be sorted by the $ Amount (as shown in the 2nd screenshot). 

[parry2k]

@vickyd totally agrees. These are important things and very hard to achieve/visualize the data. Always create an idea on the ideas forum and promote it so that it gets a vote and get the attention of the product team.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@vickyd You cannot sort by a measure until you create a calculated table which I don't think is going to work in your use case. Having said that, you are out of options here. Sorry.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[vickyd]

Thanks. That's what I thought. 

Wish the Power BI team takes a little pause and works on bringing feature parity between Exclel and Power BI tables/matrixes before moving to other things.

Little things like this do end up making the reports look a little silly with business users wondering why the report author couldn't just sort the **bleep** list by Amount :).