Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

sorting in drill down matrix

Hi    I would like to be able sort in specific order the country in regions.  the drill down opition in matrix is set up as following    Region      ->Country so for examlpe CENTRAL       Ge...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    8 years ago

    Anonymous

     

    You can create another Order Table to define the desired sorting. Then in the original table, get this related column and make the Country column sorted by the order column.

    For details, please refer to the attached PBIX file.

     

     

    Best Regards,
    Herbert

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Anonymous

 

You can create another Order Table to define the desired sorting. Then in the original table, get this related column and make the Country column sorted by the order column.

For details, please refer to the attached PBIX file.

 

 

Best Regards,
Herbert

Anonymous's avatar
Anonymous
Not applicable
8 years ago

this looks promissing .. 

one question though .. will then the sorting of the region also work .. i woudl like to sor the regions as well 

 

NORTH 1

CENTRAL 2

EAST 3

WEST 4 

 

... ect..

 

thank you 

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Anonymous

     

    If you also want to sort the region column as well, you just need to make it sorted by a column as we did above.

     

    Best Regards,
    Herbert