2021 Week 5 | Power BI: Drill Down


Thanks to everyone who participated in the first month of #WorkoutWednesday – Power BI edition. If you are joining us for the first time this week, welcome to week 5! We’ve got a new dataset and a fun new challenge! Last week you learned how to use the powerful drill-through feature. This week we’ll focus on drill down (and up), to provide end-users with control to dig into more granular data.

While we encourage everyone to participate in as many challenges as you’re able, you can start fresh with week 5 – there is no prerequisite for this report!


  • We are using a new dataset this week. Please download the starter Power BI Desktop file here. Just a quick reminder that you must be on a PC to user Power BI Desktop.
  • Note that this dataset is not built out to be a proper dimensional model. As we progress throughout the weeks we will incorporate more data modeling.
  • Create 3 card visuals containing the measures: Total Sightings, % in American Southwest, and % Suspected Hoax. Note that these measures already exist in the model.
  • Create a column chart containing Total Sightings over Time (using the Posted field for the shared axis)
  • Create a matrix visual containing the Total Sightings by Location, Shape, and Duration. Turn on the plus/minus icons to enable an alternate method of drilling up and down for your end users.
  • Use the drill-down feature to find the number of Fireball shaped UFO sightings in June 2020 in Las Vegas, NV.


This week’s data set uses data from the National UFO Reporting Center. You can access the raw data on their website in the report database. The data is brought into Power BI by date using a custom function. Do not worry – we’ve done this part for you! All you need to do is download the Power BI desktop file and start building visuals!

The dataset contains UFO sightings by Date, Location,  shape, and duration.

When you open the file, you may notice that there is a hidden tab containing resources. Please take a look for details on the source data and to learn more about drilling down (and up) in Power BI.


After you finish your workout, share on Twitter using the hashtags #WOW2021 and #PowerBI, and tag @JSBaucke@MMarie, @shan_gsd and @dataveld. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.


4 thoughts on “2021 Week 5 | Power BI: Drill Down”

Leave a Comment

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

Scroll to Top