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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Drill through with a slicer selection?

Hello,

 

I have one page with a slicer that filters the page by project name, and a button which I want to drill through to another page that will be filtered by the slicer selection from the original page. See screenshot below: Capture.PNGWhen I choose the project, the Button does not activate... it stays greyed out. If I select the project name in one of the other visuals besides the slicer, the button activates, and I can drill through to the designated page.

Is there a way I can get it to activate with the slicer selection, or a workaround which would allow me to achieve the desired functionality?

7 REPLIES 7
TeajayLikesData
Regular Visitor

I might be a bit late to the party but I have a work around to mimic drill through buttons!

 

On my dashboard I have 3 drill through buttons, 2 of which are drill through and the 3rd is fake.

 

Drill through buttons when you have no data selected for them are considered disabled and change their appearance. On the fake button, using isfiltered(), I mimic'd the disabled colours using a measure like so: 

Filtered - COLUMNNAME - TextColours = if(ISFILTERED(TABLENAME[COLUMNNAME]), "#605E5C", "#B3B0AD")

 You need to set the icon colour, text colour and border colour conditional formatting to use the above measure. This puts the colours to the default disabled colours of a button and then active colours when a column is filtered.

 

Set the action of the button to "page navigation" and add destination conditional formatting to a measure like this:

Filtered - COLUMNNAME - Destination = if(ISFILTERED(TABLE[COLUMNNAME]), "PAGE TO GO TO", "")

This "disables" the button is the column is not filtered... it is clickable but nothing happens until the slicer is filtered.

 

 

Finally set the "drill through" page to keep any filters you need to have and remove the ones you don't ie don't select keep all fitlers...Learnt that the hard way😑.

 

 

There are some downsides to this way: no right click drill through on the slicer sadly and it can be tidious to replicate. 

Also I am using the "new" slicers as of April 2024 version of PowerBi and haven't tested this with other visuals / slicers.

Anonymous
Not applicable

Since this is an ongoing battle.... I found a way to do this!  I created a button that moved from page to page, and I made sure there was a filter on both pages (making sure they are synced).  Then, on the drillthrough page, in the selection pane, I hide the slicer.  That way it is there and syncing with the previous page, but not being shown.  This is the only way I've found to do this!

v-easonf-msft
Community Support
Community Support

Hi , @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  you can add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.

 

Best Regards,
Community Support Team _ Eason

Greg_Deckler
Super User
Super User

@Anonymous what button? Like a button, button? I don't see a button in your picture.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler The highlighted "Raid Summary"on the left is a button with the drill-through (preview) action selected. It is greyed out as it is in the picture unless I click on one of the Project Names in a table visual I have not pictured. If I choose a Project Name in the slicer (like "Construction Management Funding" pictured) the button remains greyed out... I need it to become active when I make the slicer selection. Thanks!

Hi , @Anonymous 

After my research, I'm afraid it couldn't achieve based on Power BI  slicer now.

 

The bookmark button with the selection pane may achieve the effect  similar to the button activation, but it does not support matching with the slicer.  And it requires you to create a separate button for each  Project Name in the slicer.

 

For your requirement , you can come up with a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Best Regards,
Community Support Team _ Eason

parry2k
Super User
Super User

@Anonymous see if following posts helps

 

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

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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