Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Sort Area Group, Type and Rank_avgCost or Rank_avgSales in a matrix visual

I have a Matrix visual consisting of Area Group, Type, Category and have Volume, Avg Cost and Avg Sales (measures) as the values The Volume = SUM(Volume), Avg Cost = Average(Cost) and Avg Sales = Average(Sales). I created TopN parameter for my Slicer.  I created a rank based on Volume, Avg Cost and Avg Sales. These Ranks will rank Volume, Avg Cost, Avg Sales excluding Category that is selected in a Category slicer.


However, when I created a matrix visual, I sort by Area Group, Type, Category and Rank_Volume, It works fine. But when I create a matrix visual and sort by Area Group, Type, Category and Rank_avgCost, Only the Rank_avgCost is sorted but Area Group, Type are not sorted. The same thing happens with Rank_avgSales. 
How Can I sorted Area Group, Type and Rank_avgCost or avgSales. Please help

Community Support
Community Support

Hi @timmyeal ,


It is very difficult to analyze without looking at the data and just by imagining.Any chance you can share a PBIX file with dummy data?


Best Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

the sample pbix to download. Help will be greatly appreciated

I checked your files and found that the problem was in the average function.

Unfortunately ,I did my best but couldn't change the group and type sorting.

Hi V-lianl-msft,

I wrongly click on accept solution instead of reply. I don't know how to revert it not accepting solution.

Anyway, I have a sample pbix for you to look at,

If you have issue of download let me know.


Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors