Follow the Summer Olympics in Rio 2016 with Power BI!

2387 Views
Highlighted
Advisor
Posts: 95
Registered: ‎11-30-2015

Follow the Summer Olympics in Rio 2016 with Power BI!

[ Edited ]

 

Hi Power Bi community!

 

I want to share with you my personal power bi report for following the Rio Olympic Games. As I have been on vacation (and therefore havent got the time to watch TV Smiley Happy ) and I live in Europe, I wanted to have an easy way to follow my favourite countries, so I created the power Bi report shown above.

 

I have even set alerts to my favourite countries so I am always up to date Smiley Happy

 

The link to the LIVE dashboard seems to break all the time, so try this one instead:

https://app.powerbi.com/view?r=eyJrIjoiZmE1MzIxYmMtMmI5MC00ZTlkLWEwOGMtNWRlMTI2MGQ0MjM4IiwidCI6IjRmM...

 

If you want to see it live, check it on YouTube: https://www.youtube.com/watch?v=tZXY9RZwd3U

and if you want to download it, you can do it here: http://curbal.com/blog/follow-the-summer-olympics-in-rio-2016-with-power-bi

 OBS! It requires FREE membership on our site.

 

Finally, if you want to recreate it yourself, check how we built it here (Part one): https://www.youtube.com/watch?v=RKG9OLIL-Yo

 

Let me know if you have questions and I hope you enjoy it as much as I have!

/Ruth

 

 

Member
Posts: 55
Registered: ‎08-10-2016

Re: Follow the Summer Olympics in Rio 2016 with Power BI!

Hi @ruthpozuelo, great effort on the dashboard, wondering whether there is a way to hide the hyperlink , attributed to the flag icons, and simply show the name of the country, without having the whole link, once positioning the pointer on the flag. Could you please help on that and show the formula to add?

 

Thank you.

 

Atanas

Advisor
Posts: 95
Registered: ‎11-30-2015

Re: Follow the Summer Olympics in Rio 2016 with Power BI!

HI @t-atgeor,

 

I am sorry, but I don't understand what you mean:

 

Do you mean that when you place the cursor on the icon, the tooltip shows the name of the country instead of the URL?

 

Thanks for the feedback, Smiley Happy

/Ruth

 

 

 

 

Member
Posts: 55
Registered: ‎08-10-2016

Re: Follow the Summer Olympics in Rio 2016 with Power BI!

@ruthpozuelo

 

yes, exactly what I mean.

Advisor
Posts: 95
Registered: ‎11-30-2015

Re: Follow the Summer Olympics in Rio 2016 with Power BI!

Hi again @t-atgeor,

 

You can customize tooltips on bar charts but I am not aware it is possible to do on Table visualizations. To display the image you need to use that column as it is marked as imageURL, so I dont know how it could be masked otherwise..

 

Maybe somebody on the community has a trick for this?

 

/Ruth

Member
Posts: 55
Registered: ‎08-10-2016

Re: Follow the Summer Olympics in Rio 2016 with Power BI!

Hi @ruthpozuelo, exactly, image view works fine, nevertheless, will be much more comfortable not having these links to some random pages. If anyone has a solution, for this will be very grateful.

Advisor
Posts: 95
Registered: ‎11-30-2015

Re: Follow the Summer Olympics in Rio 2016 with Power BI!

Hi @t-atgeor,

 

This is not exactly what you are looking for, but if you use a shortener service like bitly.com, then your users will see that instead of a long URL.

 

/Ruth

Member
Posts: 55
Registered: ‎08-10-2016

Re: Follow the Summer Olympics in Rio 2016 with Power BI!

Hi @ruthpozuelo, already tried, however, PowerBI cannot read User friendly URLs,  only the long ones.

Advisor
Posts: 95
Registered: ‎11-30-2015

Re: Follow the Summer Olympics in Rio 2016 with Power BI!

Hi again,
I tried before I wrote to you and it worked for me. I used bitly services.
/Ruth
Member
Posts: 55
Registered: ‎08-10-2016

Re: Follow the Summer Olympics in Rio 2016 with Power BI!

Yes, works for me either, used the wrong service, any idea how to implement within a formula, so I dont have to go through 200 countries' links manually?

 

Thank you, Atanas.