sorting in drill down matrix

[Anonymous]

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 · Accepted solution]

@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]

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]

@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