Tabular Editor - Sort in Matrix in Power BI

[Evgueni4545]

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?

[parry2k]

@rjhartop good to see but not for me it is very practical and scalable but for a workaround, for sure. I will wait and hope to get this out-of-the-box functionality so recommended to vote the idea.

Thanks for sharing though.

[v-jayw-msft]

Hi @Evgueni4545 ,

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

[rjhartop]

This blog post provides a work around:

https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/

[parry2k]

@Evgueni4545 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.⚡

[rjhartop]

Hi Parry2k, just a heads up that this provides a resonable work around:

https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/