Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have done quite a few searches on this topic and there is lots of information on it. Unfortunately I am new to power bi and really struggling to understand how to take someone elses solution and mold it into mine. What I am looking for is to have a matrix chart with my machine models in the row and my countries ranked across the top. I have 153 countries so ideally I would like to show my top 10 and then put all the others into a category named other so that I see my total sales with top 10 counties and the rest in other. I also have quite a few splicers on the page (business/region/year) and am hoping to make sure it works with those.
What I have so far:
you can use a calculated coumn to give your countries a rank and use sort by column function to sort countries in the matrix visual. To group other countries that do not fall in your top 10 category use grouping function and manually select the countries and group them together
What am I missing on the ranking formula?
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |