Forum Discussion

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

Germany

Austria

Switzlerland

Poland

EAST

Russia

Ukraine

Georgia

Moldavia

I am already sorting the Region but I was not able to find a way how to distinguish the order of the countries within the region.

CORRECT sortingcurrently in PBI - WRONG

I hope someone can help me with this ..

Thank you

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
sorting in drill down matrix.pbix36 KB

3 Replies

v-haibl-msft
Microsoft 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
sorting in drill down matrix.pbix36 KB
- 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
    Microsoft 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