Forum Discussion
Sorting a Matrix After Drilldown
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?
Hi Anonymous ,
Step1, Add two columns in "Power Query".
Step2, Use 'Sort by column' feature sort the columns.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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
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
Hi Anonymous ,
Step1, Add two columns in "Power Query".
Step2, Use 'Sort by column' feature sort the columns.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
