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, can someone please help me with this one?
I am working on an olympics database and I am trying to find out Top 5 countries with highest medals and in that visual I also want to show the different types of medals.
I want to use Dax to show the Top 5 countries and don't want to use the filter pane.
The Dax measure which I am using to find the top 5 countries with highest medals is -
But as soon as I put the Medal in legend then I get 6 countries instead of 5-
Can someone please guide me as to what am I doing wrong due to which 6 countries are being shown in visual instead of 5. Also, in the Top 5 Countries with highest medals measure, if I use 10 to find top 10 countries instead of top 5 and when I have medals in Legend then I get 12 results.
My model -
Thanks in advance!
Radhika
@Radhika2605 Can you share the PBIX? Going to be easier to see what is going on that way.
Thanks for your response. Sorry file is a mess but still attaching it here.
Here is the file -
https://drive.google.com/file/d/1WXp9F9w7cbMAr7IrtWh2Mxsj2ZlwaB70/view?usp=sharing
Thanks
Radhika
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |