Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
tamara_nsb
Helper I
Helper I

Drill through button always enabled and allows "no filters".

Hi,  

 

I have a card value,  it is affected by filters from slicers and other visuals.

The user wants to be able to select the card and view the data behind the value shown.

 

I tried a drilldown but I can see the data when a filter is selected but not when nothing is selected.  Is there any way to do this?

 

When I create a drill down button it is by default disabled.   I can right click on the card,  go to drill through and see the correct data, but I can't get the button to enable,  it says I have to select a data point.

 

I have an example pbix file,  just not sure how to add it here.

 

Ex.   Card shows I have 4 values,  If I right click->drillthrough I can see 4 values.

But button is disabled  

tamara_nsb_0-1691420270809.png

 

Select category in chart for another value,  and button becomes enabled and I can click button and see 2 values.  

tamara_nsb_1-1691420323992.png

How can I see the 4 values,  and the 2 values using a button?

 

Thanks,

Tamara

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@tamara_nsb , Drill through can work on card visuals. If you add that measure to drill through page(Add Drill through page)

But as of now that is not a support button, only support of right-click

 

You can log an idea -https://ideas.powerbi.com/ideas/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@tamara_nsb , Drill through can work on card visuals. If you add that measure to drill through page(Add Drill through page)

But as of now that is not a support button, only support of right-click

 

You can log an idea -https://ideas.powerbi.com/ideas/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks for the answer,  I know the right click drill down works,  that is just not very intuitive for the users and everything else on the page is setup as a button.

I will look for another work around thanks for letting me know this is not possible.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.