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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
BigLo
Helper II
Helper II

Display Drilltrough Active Filters

Hi,

 

When I use a Drillthrough, the slicers don't consider my filtered data as existing.
So, for the user, the slicer displays 'All'.


I want to display the filters activated by the drilltrough (or the active fields in the view). I was thinking using a measure (or bookmark to compare difference) but I don't know how to do it?


Do you have a solution or a workaround for me?

1 ACCEPTED SOLUTION

I didn't want to use the "Keep all filters" function.
I used the 'isfiltered' formula to check if the field is filtered. Then the 'Concatenex' function to display the values.
I display everything in a card so that the user can see the active fields. It's not perfect, but it works.

View solution in original post

2 REPLIES 2
v-yetao1-msft
Community Support
Community Support

Hi @BigLo ,

Please correct me if I wrongly understood your question.

Maybe you can learn more about Keep all filters function in Drill Through pane.

When you turn on the Keep all filters , the data that filtered by slicer will display in the page you drill through .

Ailsa-msft_0-1618278737113.png

You can also refer to document

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

 

Best Regards

Community Support Team _ Ailsa Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I didn't want to use the "Keep all filters" function.
I used the 'isfiltered' formula to check if the field is filtered. Then the 'Concatenex' function to display the values.
I display everything in a card so that the user can see the active fields. It's not perfect, but it works.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors