Power BI Matrix visual values sorting

[Bilal_Niazi]

Hi, I created a matrix with sales, the sales YoY variance and var%. I have separate date table connected to the Sales table. I want to see the sales KPIs by year and customers. Everything is working fine in this matrix except sorting. I want to sort the sales in ascending or descending order. Sometime, I want to see Variance or Var % in ASCE or DESC order but nothing works for me here. I tried to use the sort axis option coming with the matrix itself but this doesn't sort the sales correctly. I tried RANKX but no results. Is there any way to sort the Values in matrix?

[Ritaf1983 · Accepted solution]

Hi @Bilal_Niazi 
Please refer to my answer in the linked discussion :

https://community.fabric.microsoft.com/t5/Desktop/Matrix-ordering-by-specific-column/m-p/4286999

If my answer was helpful please give me a Kudos and accept as a Solution.