Forum Discussion
Drill through with a slicer selection?
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.