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

Welcome back to day twenty-two of our thirty-day series on Success in Power BI!  Have you forgotten where we left off from day twenty-one? If so, here is the link to refresh your memory.

Now that we’ve learned how to drill down in a matrix table, let’s see how to drill down in a visualization.  Highlight the matrix that we used in days twenty and twenty-one and select the Stacked Column Chart in the visualization menu. This will convert our matrix table to the stacked column chart using the same selected fields OrderDate and SalesAmount as shown in Figure 1.

Figure 1 – Stack Column Chart

This is the same data now represented as a chart.  If we right click on one of the stacks, as shown in Figure 2, we see a Drill Down option. Notice that there is also a Show Next Level and Expand to Next Level options.

Figure 2 – Drill Down Options

  • If we choose Drill Down it takes us to Sales Amount by Year and Quarter and in this case it is 2013.
  • If we choose Show Next Level, it takes us to Sales Amount by Quarter. This is an aggregation for all years by quarter. There is a difference here between seeing a drill down into 2013 data and looking at the next level of the hierarchy.
  • If we choose Expand to Next Level, as shown in Figure 3, we see a break-down by year and quarter for Sales Amount.

Figure 3 – Aggregates by Year and Quarter

These are subtle differences but very important differences.  We can continue drilling up or down to see the various levels for this chart in much the same way that we did for the matrix table. Note that the up and down arrows are available above the visualization here as well. Stay tuned for the drillthrough in our next installment.


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 June 12, 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 )

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: