Forum Discussion

JulieKucher's avatar
JulieKucher
Frequent Visitor
9 months ago
Solved

Drill through from a card

I need to make sure that user can drill through from summary page to the details page from the card. The tricky part is that on the summary page there are 4-5 filters like Year, month, location, contact. And the card value will change when the filter is used. When the user drills through from the card, the same filters should stay applied in the details page. There might be cases when user might select multiple options in the mentioned filter, e.g. couple of years - not just 1 year. 

 

1) How to make card work with drill through? 

2) How to make the filters in the summary page to be in sync with the details page while drilling through? 

 

Thanks to all who commented! 

  • Hi JulieKucher 

    It is possible to drillthrough from a card with measures alone but the visuals in the destination page must contain these measures as a visual fitler or displayed in the visuals themselves.

     

     

7 Replies

  • Hi JulieKucher 

    It is possible to drillthrough from a card with measures alone but the visuals in the destination page must contain these measures as a visual fitler or displayed in the visuals themselves.

     

     

  • Hi JulieKucher 

     

    Cards don’t support native drill-through on click. So, we can use a Drill-through button instead.
    Create a button. Select button and navigate to Action - choose Drill through and select Details page. Card shows the value and the button performs the drill-through.


    On the Details page, add all relevant fields (Year, Month, Location, and Contact) to the Drill-through filters as well. When users select single or multiple values on the Summary page, Power BI automatically passes them during drill-through. Enable 'Keep all filters' on the button to also pass visual/page filters

  • You can make the card display a measure and then on your drill through configuration for the page, just put the measure as the drill through field.  On the drillthrough config make sure the "Keep all filters" toggle is set to on (it is by default)

     

     

  • NimaiAhluwalia's avatar
    NimaiAhluwalia
    Icon for Continued Contributor rankContinued Contributor

    Hello JulieKucher 

     

    Hope my solution helps you.

     

    You can now drill through directly from a Card visual while keeping the same filter context (Year, Month, Location, Contact including multi-select) that was applied on the summary page. Configure the target page with drillthrough fields, then use the card’s right-click/context menu to drill through; Power BI will carry over the current slicer and filter selections to the details page automatically. If your intent is different (e.g., drillthrough to a specific entity rather than the card’s overall context), the setup may need an alternate pattern.

     

    Please follow the demo

     

    https://www.youtube.com/watch?v=b8OCphhk_LE

     

  • 1) How to “drill through” from a card

    Use a Button (or Shape) placed next to/on top of the card:

    1. Create your Details page.

    2. Add a button on the Summary page → Action = Drill through → Destination = Details page.
      (If Drill through is not available, use Page navigation instead — see below.)

    3. Style the button to look like part of the card (e.g., “View details”).

    Important: Drillthrough normally expects at least one drillthrough field on the Details page. If you don’t actually need to pass a specific “entity” (like CustomerID), and you only want “same filters, more detail”, then you don’t need drillthrough at all—Page navigation is the cleaner tool.

     

    2) How to keep Year/Month/Location/Contact filters (including multi-select)

    On the button action, turn on:

    • Keep all filters = On

    That’s what preserves:

    • slicer selections

    • multi-select (e.g., multiple years)

    • page/visual filters

    Optional (nice UX): if you also want the slicers to visually show the same selections on the Details page, use Sync slicers (View → Sync slicers). This isn’t required for the filter context to carry over, but it makes the experience consistent.

  • Hi JulieKucher,

    Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to danextian, cengizhanarslan, NimaiAhluwalia, krishnakanth240,  for those inputs on this thread.

    Has your issue been resolved? If the response provided by the community member danextian, cengizhanarslan, NimaiAhluwalia, krishnakanth240,  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

    Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

    Thank you for using the Microsoft Community Forum.

  • Hi JulieKucher ,

    Could you please let us know whether your issue has been resolved, or if you are still facing any issues. If you need any additional details or clarification, please feel free to let us know.

     

    Thanks.