Create a Multi-Selection Drillthrough 'Button' in Power BI

Learn how to create a "button" with right-click Drillthrough functionality using single value cards in Power BI. This works great when selecting multiple rows from a matrix table, or multi-selections from other visuals.

RELATED CONTENT 🔗

BECOME A CHANNEL MEMBER 🎉

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:30 - Content Intro

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax

[Codeeeeee]

Love the content Reid - almost as much as I love that shirt.

[kavyach]

Hello! I tried to replicate the same process and could get a functionality of color and text changes in the card visual, but I do not see any action for a card visual? How do I do make it work on single click which takes me to drill through page? I could make this with a button (enable/disable on selection) - but only with single data point. Appreciate your effort and request you for help.

[mecaroma]

Hi Reid! I’m just starting out as a Power BI model developer. I came across your video for an exact scenario I’m trying to build right now. I see you have a bunch of DAX measures built for the drillthrough and I’m wondering if you have a video that shows how to build those out in order to use them during this multi-selection process. Appreciate the great content you’re providing!

[april]

Hi, thank you for sharing. I did exactly what you have shown in the multi select drill through button, but the single card doesn't show the drillthrough when I right click it. Is there any trick I might be missing? Thank you!

[SergiyVakshul]

Reid, on 'Drillthrough Page' you have a slicer for brand names. If the slicer has filters applied, then the result of drilling through might be confusing because of these extra filters.

[halliegromek]

Have they come up with a more elegant drill-through yet?

[CeciliaB]

Hi Reid, it's really amazing and works perfectly! I have a question and hope you can help. I was trying to select multiple datapoints from different visuals and drill through. However, PBI removed my selection on the first visual when I tried to select the second visual (I held down 'Ctrl' key but it didn't work). Do you have any clues? Appreciate your help :)

[kapudamodhar]

Hi Reid, is there any chance to select all for Drill Through

[narendrababu]

Is there any possible way to drill through by clicking on single data point. I don't want to right click and and click on drill through?

[GaiusGW]

when i click on results in a table, I am able to ctrl click to multi select and i do see the card change the text to right click etc but when i right click on it, no drill through option. i do have drillthrough on the next page and can do individual. not sure what i could be missing.

[MrAszpic]

I can't make it work, has the feature been disabled?

[bandarth]

you didnt show to enable the drill through

[Wzxxx]

I spent 3 days to figure out why my visual title (created with a measure) does not change according to change on the visual by filtering it. Now You have confirmed that it jus doesn't work in Power Bi, thank You. This is ridiculous.