topic Re: Follow the Summer Olympics in Rio 2016 with Power BI! in Data Stories Gallery

Follow the Summer Olympics in Rio 2016 with Power BI!

ruthpozuelo — Tue, 13 Sep 2016 09:14:53 GMT

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 :) ) 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 :)

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

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

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

eyJrIjoiZmE1MzIxYmMtMmI5MC00ZTlkLWEwOGMtNWRlMTI2MGQ0MjM4IiwidCI6IjRmMWNiNzZmLTlhODUtNDc3Mi04MWIwLTVkYWVjZjlmYTQyMCIsImMiOjh9

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

t-atgeor — Thu, 01 Sep 2016 09:15:03 GMT

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

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

ruthpozuelo — Thu, 01 Sep 2016 09:52:15 GMT

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, :)

/Ruth

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

t-atgeor — Thu, 01 Sep 2016 09:58:08 GMT

ruthpozuelo

yes, exactly what I mean.

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

ruthpozuelo — Thu, 01 Sep 2016 10:10:50 GMT

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

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

t-atgeor — Fri, 02 Sep 2016 07:49:35 GMT

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.

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

ruthpozuelo — Fri, 02 Sep 2016 10:13:07 GMT

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

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

t-atgeor — Fri, 02 Sep 2016 10:15:32 GMT

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

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

ruthpozuelo — Fri, 02 Sep 2016 10:23:28 GMT

Hi again,
I tried before I wrote to you and it worked for me. I used bitly services.
/Ruth

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

t-atgeor — Fri, 02 Sep 2016 10:34:04 GMT

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.

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

ruthpozuelo — Fri, 02 Sep 2016 10:55:44 GMT

Hi!
You can only use power bi to Generate the bitly links if you understand how they made them, and that is no public information (?).

So, you need to generate the bitly links in bulk using their service and then import them in power bi.

I found this service that claims to do just that: (have not tested it myself) https://www.hostingkingdom.com/blog/bitly-bulk-url-shortener-tool/

Once you get the links in google docs, you can import them directly into Power Bi.

Hope this helps, Ruth