• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
    • Learning Resources
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Template Apps
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / Microsoft Power BI / Follow the FIFA World Cup 2018 in Power BI
Follow the FIFA World Cup 2018 in Power BI

Follow the FIFA World Cup 2018 in Power BI

posted on June 4, 2018

It is world’s cup fever: FIFA world cup 2018 in Russia!!! And we dont want to miss anything right?

That is where Power BI comes to the rescue 🙂

I am going to build a Power BI file to follow the world cup and I decided to show you how I create it while creating it 🙂

Get Match and Group Data in Power BI

In this first video, I have downloaded in Power Bi the world cup data from FIFA world cup 2018 website.

I have downloaded and clean when the matches occur, the groups and the flags.

Matches Schedule

In this part 2, we will create our first report that will answer this questions:
1. When is my favourite group playing?
2. When is my country playing?
3. Which matches will be sent today and at what time?

….and much more.

Take a look at how that was created in the video below or download the pbix file at the bottom of the page:

Adjust for Local TimeZones using parameters

In Part3, I will show you how to adjust the match times for your local time using parameters:

Get Flags through inactive relationships

In part 4, I show you how to work with inactive relationships using DAX.

Get Knockout Phases

And in Part 5 video, I will show you how to download and visualize the knockout phases in Power BI.

Update the knockout Phases dynamically

In Part 6, we are going to make the knockout phase update dynamically when the games start:

Predict the World cup winners with PowerApps

Predict the world cup series with PowerApps. Download and install the app in just 10 minutes!!

Members Download center:

This download is for Curbal Members only. If you have a membership, please login and download the files from our download center *HERE*, if not, register!

The Final Report

And here is the report live or here.

Filed Under: Microsoft Power BI

Join our community of over 20,000 professionals

Become a Member

Subscribe to YouTube

Reader Interactions

Comments

  1. Orlando Mezquita

    June 16, 2018 at 2:17 pm

    Hi Ruth!

    Check the link for the back button on the Standings page. It doesn’t seem to be working.

    Reply
    • Ruth Pozuelo Martinez

      June 16, 2018 at 3:04 pm

      I will fix it this evening 🙂

      Reply
    • Ruth Pozuelo Martinez

      June 16, 2018 at 6:24 pm

      DOne 🙂

      Reply
  2. Ruth Pozuelo Martinez

    June 14, 2018 at 10:06 am

    Thanks!! 🙂
    /Ruth

    Reply
  3. Alaeddin Badran

    June 14, 2018 at 5:56 am

    Heyy .. regarding the hierarchy chart always collapsing, just go to the visual settings –> Node –> set the Node value to 4. Problem solved 🙂

    Reply
  4. Alaeddin Badran

    June 13, 2018 at 3:29 pm

    Awesome!
    For some reason the file can’t be downloaded! I’m getting an error message “Unable to download file(s)”

    Reply
    • Ruth Pozuelo Martinez

      June 13, 2018 at 3:52 pm

      Please try again, I just fixed the link1
      /Ruth

      Reply
  5. Arimitra Maiti

    June 5, 2018 at 9:03 am

    Hi Ruth, Is there a way to create a dual axis line chart like excel in Power BI? For example in primary axis I would have a numeric measure showing a line chart and same in the secondary axis and in x axis I would have month-yyyy. I checked this link below https://community.powerbi.com/t5/Desktop/Dual-Y-axis-in-Line-chart/td-p/120717

    However I could not find a solution to this. I know this question is not relevant to this post but the email feature from this website is not working for me today.

    Reply

Let us know your thoughts... Cancel reply

Primary Sidebar

Search Website:

Subscribe to our YouTube Channel (50k subs)!

Apply for Membership (+20,000 members)

Become a Member

Awards: MVP Data Platform

MVP Data Platform Ruth Pozuelo Martinez
Microsoft MVP Profile Page

About Ruth:

Speaking gigs:

Footer CTA

Join our community of +20,000 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 10
722 13 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2021 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In