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.
Hello,
I have an assignment to create some visualizations using data from https://www.kaggle.com/heesoo37/120-years-of-olympic-history-athletes-and-results/discussion/120222.
I am new to excel and power BI and was wondering if someone could teach me how to do this. I've tried playing around with it but they aren't turning out quite how I would expect. I would like to create a map of the top 10 medals by country and also a table to list the top 10 male athletes by height.
Any help appreciated.
Solved! Go to Solution.
@Wunderful - View the attached PBIX file and let me know if that's what I was looking for to accomplish. If so, we can explain what I did or you may be able to find out by looking at the settings around. PBIX is below sig.
Hi @Anonymous ,
You may create measures like DAX below, then go to Filter pane, set the relative Ranking field as Top 10.
Ranking Gold medals =
RANKX (
CALCULATETABLE ( VALUES ( Table1[Country] ), ALLSELECTED ( Table1[Country] ) ),
[Gold medal Amount]
)
Ranking Height =
RANKX (
CALCULATETABLE ( VALUES ( Table1[Athlete name] ), ALLSELECTED ( Table1[[Athlete name] ) ),
[Height]
)
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Wunderful - View the attached PBIX file and let me know if that's what I was looking for to accomplish. If so, we can explain what I did or you may be able to find out by looking at the settings around. PBIX is below sig.
Hello,
It looks like what I am going for. I'll take a look at the settings and see if I can figure it out. Otherwise I'll come back and ask how you did it.
Thanks,
AB
@Anonymous , the icon display as bar, its one you need a check for custom visual /infographics visual
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380898?tab=Overview
https://www.youtube.com/watch?v=XwOIIuRg-EI
for icons check to you medal icon in unichar
https://exceleratorbi.com.au/dax-unichar-function-power-bi/
how to use
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
For top 10 , you can use Rank or top 10
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
https://databear.com/power-bi-dax-topn-function/
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
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 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |