Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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, Moderat...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
v-lionel-msft
Community Support
5 years ago

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.