Help Creating Visualizations

[Anonymous]

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.

[v-xicai]

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.

[Greg_Deckler · Accepted 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.

[Anonymous]

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

[amitchandak]

@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