Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I hope someone can help me with this ..
Thank you
Solved! Go to 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
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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |