Forum Discussion
Tabular Editor - Sort in Matrix in Power BI
Hi! I created 2 Calculation Items in Tabular Editor: Current Month and Last Month. And my selected measure was Revenue. I am trying to sort stores by Current Month revenue, from biggest to smallest.
I created a matrix and put Stores in Rows, Revenue measure in Values, and the Name (calculated items) in Columns.
The issue: The matrix does not allow me to sort by the calculated items Current Month/Last Month.
Could you please let me know if there is a way to click on the column and sort by a calculated item?
5 Replies
Anonymous I don't think so, matrix visual doesn't allow to sort by columns, doesn't matter if you use calculation items or category column.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡
Hi Parry2k, just a heads up that this provides a resonable work around:
https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/
Hi Anonymous ,
It's not supported to sort the matrix by column and we could only sort it by total value.
You may vote for this idea.
https://ideas.powerbi.com/ideas/idea/?ideaid=05c64cd1-c0d0-44d3-bceb-21f4acc0e548
Best Regards,
Jay
This blog post provides a work around:
https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/
