30 Days to Success in Power BI: Day Nineteen Take Power BI to Another Level

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

For the next few blog posts we are going to discuss taking Power BI to another level. We are going to discuss drill down (or up) and drillthrough.

Let’s explain the terminology first!

With drill down, we can go from a high level on a report like Year to Date Sales to the lowest detail that we wish to show.  We can decide how many levels of drilling.  So let’s say our first level is corporate-wide so we might see one row for 2017 that has sales data totals for the entire corporation. If we drill down to the next level, we can see that inside the corporation we now have totals by global regions. If we drill down a little further we might see totals by country and then totals by smaller regions and so on.  Drilling up is simply going back up that chain.  This adds an entirely new dimension to our reports that eliminates the need for multiple static reports.

Drillthrough, on the other hand, provides the ability to drill through to another page or report for detail and thus filter by the field that you selected when you chose drillthrough.  For example, when we have our drill down and we get to the country detail on our report mentioned above, we could drillthrough to a second report that shows sales details and it would then filter by that country.

If this sounds a little confusing, do not fret…we will go through it in the next couple of posts.  Stay Tuned!



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 October 18, 2017, 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: