Formula 1 analysis - 1950 - 2021
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.
4 Replies
Nice work 🙂
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
