Forum Discussion
Drill Down in key card
Can we do a drill down in a key card do we an option for that?
To make it more clear I'll explain by an example suppose I have a key card of cancelled flights (for a day) now if I click on that particular key card it will give me information about what were all those cancelled flights for that day.
Hi Anonymous ,
by default, the drill-down feature isn’t supported in Card visuals in Power BI.
A common workaround is to place a transparent button (set the background to 100% transparency) over your card visual. You can then configure the button’s action to navigate to a detailed page showing the table of cancelled flights. On that detailed page, you can also add a back button to return to the main/home page.
You can also check below link for applying drill-through feature for card visual :
https://community.fabric.microsoft.com/t5/Desktop/Drill-through-from-a-card-with-a-measure/m-p/3338950
5 Replies
- AnkitaaMishra
Super User
Hi Anonymous ,
by default, the drill-down feature isn’t supported in Card visuals in Power BI.
A common workaround is to place a transparent button (set the background to 100% transparency) over your card visual. You can then configure the button’s action to navigate to a detailed page showing the table of cancelled flights. On that detailed page, you can also add a back button to return to the main/home page.
You can also check below link for applying drill-through feature for card visual :
https://community.fabric.microsoft.com/t5/Desktop/Drill-through-from-a-card-with-a-measure/m-p/3338950 Hi Anonymous ,
Thank you for reaching out to the Microsoft fabric community forum.
I wanted to check if you had the opportunity to review the information provided by AnkitaaMishra . Please feel free to contact us if you have any further questions.
Thank you.
- Poojara_D12
Hi Anonymous
In Power BI, the Card visual itself doesn’t support drill down like charts do, because it only displays an aggregated single value. However, you can achieve the behavior you want by using cross-filtering and drill-through. If you place your “Cancelled Flights” count in a Card and then also have a detailed table or chart on the same report page, clicking on the Card won’t drill down but it can act as a filter if you instead use a measure inside a different visual. The more common solution is to enable a drill-through page: you create a separate report page that shows detailed flight information, set up drill-through filters on “Date” or “Flight Status,” and then users can right-click the Card (or another aggregated visual) and choose Drill Through → Details, which will take them to the list of cancelled flights for that day. Another option is to use a button or bookmark navigation so that when users click the high-level KPI, they’re taken to a page with the detailed breakdown. So while you can’t drill directly inside a Card, you can design drill-through or navigation patterns that achieve the same effect.
