Sorting each filter on a report separately Cannot be done?

[datadelta]

I have a report showing a set of customers and then each store.  I was hoping to sort each store on their own but if you sort one filter as ascending, you can't do the same for other filters withing that matrix.

I know I'm working on my ranking DAX but I thouth this would be easier.

[parry2k · Accepted solution]

@datadelta in table visual, you can sort on multiple columns but not in matrix

✨ 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 · Accepted solution]

@datadelta once you sorted the first column, hold shift and then click on the header of the 2nd column, by clicking it will change ascending to descending.

Basically, you need to hold shift to sort on multiple columns.

✨ 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.⚡

[sm_talha]

You can do this by adding a sort column for stores and use "Sort by Column" option to sort store by "sort column", once you do that, if you sort the matrix visual by customers, the stores will be sorted for their own automatically. 

[datadelta]

Thank you.  I'm not following what you are suggesting.  How do you mean?

[sm_talha]

can you please show a sample of data and visual that what are you trying to achieve? 

[parry2k · Accepted solution]

@datadelta in table visual, you can sort on multiple columns but not in matrix

✨ 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.⚡

[datadelta]

Thanks.  I changed to table visual but the individual columns change as I ask it to sort by highest to lowest by item.  So, I change one item to highest sale and then try to change the next item column and the first one shifts back to it's original order but the new item is now sorted by highest.