30 Days to Success in Power BI: Day Twenty-One Drill Down

Welcome back to day twenty-one of our thirty-day series on Success in Power BI!  Have you forgotten where we left off from day twenty? If so, here is the link to refresh your memory.  In our last post, we saw how to setup the drill down capability. Today we will see it in action.

To recap quickly, we were using the AdventureWorksDW2014 data warehouse and we added  SalesAmount and OrderDate from the FactInternetSales table.  We want to insert a matrix table onto the report as those work with the drill down feature whereas the regular table visualization does not.

Figure 1 – Initial Sales Amounts

In Figure 2, we can see drill down icons for the Matrix visualization. The down arrow on the right side of the toolbar enables the drill down capabilities for the visualization.  The three arrow icons in the left hand corner have the following functionality:

Figure 2 – Drill Down Icons

  • The Up Arrow drills up a level from the current level of the hierarchy.
  • The Double Arrow drills down to the next level of the hierarchy (as seen in Figure 3).

Figure 3 – Move Down One Level

  • The Single to Double Arrow expands down all to the next level of the hierarchy (as shown in Figure 4).

Figure 4 – All Down One Level

With this feature we can roll up and down allowing Power BI to do the aggregations along the way.  In Figure 5, we can see the bottom level showing sales aggregates for year, quarter, month, and day. At this point you can visualize the roll up for the totals.  We have now learned to use the drill down feature of Power BI. Congratulations!

Figure 5 – All The Way Down



About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on May 15, 2018, in Business Intelligence, PowerBI and tagged . Bookmark the permalink. 1 Comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: