Forum Discussion

vickyd's avatar
vickyd
Helper V
4 years ago

Sort each level in Matrix differently

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 t...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

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's avatar
    vickyd
    Helper V
    4 years ago

    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 :).