How to Drillthrough on a Card Visual in Power BI

In this video Mitchell shows a cool Power BI Trip to leverage drillthrough capability on a card visual.
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
00:00 - Introduction to Drilling Through a Card Visual in Power BI
00:47 - Explanation of Drill Through Functionality in Power BI
01:19 - Setting Up Drill Through Filters on a Page in Power BI
02:46 - Configuring Drill Through Filters by Adding Columns
03:49 - Demonstrating Drill Through Capability on a Table Visualization
04:48 - Addressing the Challenge of Drill Through on Card Visuals in a Dashboard
05:49 - Solution: Using a Measure to Capture Filters for Drill Through
06:21 - Application of the Measure to Enable Drill Through on Card Visuals
07:59 - Importance of Adding Specific Measures for Drill Through Capability
08:30 - Closing Remarks
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZbin: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@pjchacon]

I was wondering how to do this yesterday, and I found this video on my KZbin feed today! I'm creating a dashboard that will use this exact approach. Thank you for such an informative video!

[@HuffrsZoe]

I NEEDED THIS!!!! Thank you so much!!!

[@Rkas33774]

Great tip thank you!!

[@user-vd9vd3dq7h]

Thanks for this Awesome Video, saved me a lot of time creating measures to do the same thing

[@marcofogale9719]

That's is a great tip! Thank you a lot!

[@nadasdij]

Awesome thanks

[@vipulkumarsingh6375]

That's is a great tip! Thank you a lot! 🙂

[@edugieomoluru874]

Great insight

[@bradj229]

Nice! Thanks!

[@davidjosevarelagarcia7011]

excelente, gran aporte. sds.

[@phoenixoo7]

I didn't know this would be possible... Thanks for the this cool video...

[@Buhlebendalo_Mavika]

this is helpful, but for my measures, it doesn't wok. Say I have a table that has the project start date and status and the works. The measure I created filters specific projects, like "Active but overdue" is possible to drill through and it gives me that particular information. Right now all it does it give an overall table. Thank you.

[@stanhosie2418]

Been tearing my hair out trying to figure out drill through on a card, many thanks

[@tanmaysharma3673]

A very good video, thank you! But can you please tell if the card is showing a filtered value from a graph interaction then can we get the drill through view with that interacted filter value. For example we have 3 visuals like 1 Stacked bar chart visual, 1 Card Visual and 1 table visual and interaction is active for all three. Now if we clicked a single bar and then the measure applied in card is showing the calculated value for that selected bar and then we apply drill through on card it shows the total instead the count from selected bar...

[@walidkhlil2872]

Tack

[@collardgreens1275]

Great tip, Is it possible to select a card and drill through using a separate button though? My users struggle with right clicking and I usually just make a "See Details" button to allow for drill throughs. I found one work around where I could make a transparent graph already filtered to what I needed over the top of the card so if they click the card they are actually selecting the transparent graph. Then use the "See Details" button. It is kind of a ridiculous work around though and it makes it hard for the user to know if they have selected the card or not.

[@sajadahmadi595]

❤❤❤

[@hi_vishy]

Wow

[@NiamhCostello-en6mf]

i dont have the drill-through option under visualisations :(

[@user-if5uv6ws9i]

How to do that but without right click on the card but just left click on it (like a button?)

[@asthaarora-de6xi]

i followed the exact same thing, but it is not working for me

[@Nixter237]

I was having issues as well. My experience is limited, but I believe the issue is that the value that we are drilling on (What is shown in the card) has to be a measure. If you are using text it can be a pain. so I made measures that will hold the text I wanted - Customer Drill = CONCATENATEX(VALUES(Table[Column]), 'Table'[Column],",") There may be a better way but this worked for me.