Improving My COVID Power BI Report - Excelerator BI

Improving My COVID Power BI Report

As is almost always the case when building Power BI reports, the first version is just the start of the journey, not the final destination. This article is a follow up from last week where I showed you how I built my COVID Power BI report from scratch. This week I am going to take you through the process I went through of starting to make improvements to build a better version 2.0. Improvements in version 2 include:

  • Repoint the local data source to a live online data source (so I don’t need to manually update the source data each day)
  • Break the link to the local Excel file that is used to set the phases so I can schedule the refresh of the report without OneDrive or a gateway.
  • Build a lead/lag adjustment to time phase align the cases with deaths – you don’t want to miss that one.
  • Make the report multi country select, including improving the chart labels
  • Improving some of the visualisations so they are easier to read

Here is the video

Here is a Copy of the V2 workbook if you would like to take a look.

What Shall I do Next?

Let me know in the comments below how you would like me to continuously improve this report so it is more useful and user friendly.

11 thoughts on “Improving My COVID Power BI Report”

  1. Hi, Matt,
    In the measure [Report Title], if two or more countries are selected in the Filter Pane, how does the measure [Report Title] shows the selected countries?
    Thank you.

    1. Hi Dennis,
      In the V2 report attached in the article, you will notice that the [Report Title] and the [Chart Title] measures are both using the SELECTEDVALUE() function.
      Neither of the measures currently offer an Alternate Result, thus if multiple countries are selected the SELECTEDVALUE() function will return a blank in the space of the country name.

      In a situation where you want to have more than one valid country selected at a time, you would be best replacing the SELECTEDVALUE() function with CONCATENATEX().
      Report Title = “COVID Case Fatality Rate in ” & CONCATENATEX(VALUES(Country[location]), Country[location], “, “)

    1. Unfortunately it looks like that page you linked using some sort of Javascript to generate the page. I would not be able to extract data from that webpage. It’s very frustrating, actually. I much prefer to get the source data and let me at it. Getting the data is the hardest part

    2. Hi Sylvain,
      It is possible to extract the information visible on the landing state of the page (i.e. the first 30 rows), using the new Web Table Inference feature.
      Unfortunately, at this time, I am not aware of a way of accessing all rows of the table.

  2. Duncan Williamson

    That was a really enjoyable experience: I will learn what you did in Power BI. And thanks for the mention, too.

  3. Fabulous! Have you considered changing granularity to compare States? I am trying to do so for the US.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top