Sorting a Matrix After Drilldown

[Anonymous]

Hi,

I have a set of data with Counties and States that I am sorting by total customers, but when drilling down I would like the order to stay uniform. I would like the order to stay High, Moderate to High, Moderate to Low, and Low and not sort by Total Customers.  Is this possible?

[amitchandak]

@Anonymous , you need to have sort column for customer type(High, Moderate to High, Moderate to Low, and Low) and then sort the matrix on rows .

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

Thanks for the response @amitchandak!  I do have a sort column for the cutomer type. But I want to keep the sort as overall by total customers, and just sort the drill down from High to Low. For example since KY - Jefferson has the most customers it would be the top, but when I drill down it would go from high to low customer type no matter how many subs are in those categories

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Step1, Add two columns in "Power Query".

Step2, Use 'Sort by column' feature sort the columns.

Best regards,
Lionel Chen

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