How to Drillthrough on a Card Visual in Power BI

In this video by Mitchell Pearson, the process of drilling through on a card visual in Power BI is explained in a straightforward and easy-to-follow manner. Drilling through is a valuable feature that enables users to explore detailed data from a summary visual, such as a card, by filtering and navigating to a more specific page in Power BI.

What is Drillthrough in Power BI?

Drillthrough allows users to pass filters from one page to another in Power BI. This feature is particularly useful when you want to gain deeper insights into aggregated data represented in visuals, like a card. The main objective of drillthrough is to navigate from a summary visual (like a card) to a detailed report, keeping the original filters intact.

Steps to Drillthrough on a Card Visual

1. Create a Drillthrough Page: Start by creating a drillthrough page. This page will display detailed information related to the summary data in your card visual.
2. Set Drillthrough Filters: On the drillthrough page, add a drillthrough filter by dragging and dropping the relevant attributes from your data model into the drillthrough filter area. This ensures that any data passed from the summary visual will filter according to those attributes.
3. Enable Drillthrough on Card Visual: Once the drillthrough filter is set up, navigate back to the card visual. Right-click on the visual and choose the "Drillthrough" option to access the detailed report filtered based on the original data.

Drillthrough with Card Visuals

Mitchell demonstrates how this process works using a card visual to summarize sales data. By right-clicking on a card visual, users can drill through to a more detailed report, which shows all relevant data, like transaction history and customer details, based on the selected card value.

Using Measures in Drillthrough

To drill through on a card visual that displays a measure (e.g., total sales), Pearson highlights a simple trick: add the measure to the drillthrough filter. This ensures that when users drill through, they see all the relevant detailed data linked to that measure, maintaining consistency across visuals.

Handling Filters from Other Visuals

A common issue occurs when filters from other visuals on the page are not passed correctly when drilling through. Pearson shows how to configure the drillthrough page to retain all filters applied on the main page, including those not directly related to the card visual.

Advanced Drillthrough Setup

For more complex reports with multiple card visuals, Pearson demonstrates how to manage different measures in drillthrough. By adding multiple measures to the drillthrough page, you allow users to drill through on any of them, ensuring that the filtered data remains relevant to the context of the visual they are interacting with.

Final Thoughts

While drillthrough on card visuals may seem challenging at first, it is a powerful tool for enhancing your Power BI reports. Mitchell Pearson’s approach offers a simple, effective way to make your visuals interactive and insightful. By following the steps outlined, Power BI users can leverage this feature to access more granular details, ultimately improving data analysis and decision-making.

For more tips and tutorials on Power BI, make sure to visit Pragmatic Works for expert training and resources.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power BI and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.