Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
09-02-2021 16:19 PM - last edited 09-02-2021 16:20 PM
With this Power BI report, we've combined two of our favourite things - Formula 1, and data visualisation!
Using data from Kaggle, we have analysed over 70 years worth of Formula 1 statistics, providing a detailed breakdown of the most successful drivers and racing teams from 1950 to 2021.
Users can browse through the statistics across 4 areas: Drivers, Teams, Seasons and Circuits.
Data source: Formula 1 World Championship (1950 - 2021) | Kaggle
Follow Datavue on LinkedIn for more content like this.
eyJrIjoiODJmNDJiNDUtNGVkZC00OGE2LThhMDctYjQ5NTA4ZGQ5OWJkIiwidCI6IjQyMGNlMjhhLTgwMDAtNDk0Ni04MGMzLWIyYmY3YzM1MTQ3NCJ9
Great report
Can you tell us which visualizations are used on the first and second pages?
Dear John,
I enjoy your report. It's almost perfect 🙂
You can enrich it with hyperlinks to Google, Wikipedia, or another person/event homepage.
Create a measure, like this:
Google = "https://www.google.com/search?q= " & max('Table1'[Field1])
where Field1 is the name of the driver, for example.
To use the URL Icon, which only shows a paper clip that you can click on, in a Table visual:
The data MUST start with HTTPS:// or HTTP:// or be an email.
Simply categorize your data (col or measure) as "Web URL" in Data Category, then under Format choose Values and turn on "URL Icon".
Every URL will turn into a paperclip which doesn't take much space.
See:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
It will look like this:
Good health.
Arie
https://www.power-bi-free-templates.com
Nice work 🙂