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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
y5famfnatudu
Helper III
Helper III

Reset a single filter in a drill-through filter pane

Hello,

 

I have a drill-through page where multiple filters are passed to. Is there a possibility to have a button in the drill-through page that resets only one filter from the passed filters?

 

y5famfnatudu_2-1683649277664.png

For example, this Status that will be passed to the drill-through page, I would like it to be reset, so that I see all of the available options in this slicer.

 

Best regards,

Simon

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @y5famfnatudu 
Yes. Just turn the option of "keep all filters" to "off"
And remove the filter that you don't need

Ritaf1983_0-1683687593602.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

7 REPLIES 7
RajaCSN
Helper III
Helper III

I think @Ritaf1983 has suggested the right thing. I have intially created two filters on a drill-through page. Please check this image where keep all filters is kept ON.

 

ON.JPG


Now, I am appling an year filter in summary page as well a specific state and segment and try to drill-through.

 

Scenario image:

TWO.JPG

In addition to the State and Segment filters this too will be passed to the result page. Please check this image:

THREE.JPG

When you look at the CARD showing the selected YEAR, that was not initially set to be a field to filter the data. However that is effected becasue of the "ON" Status.

 

However when you SWITCH OFF "Keep all filters" option, only the designated filters that you have defined in your drill-through page will be applied.

 

Hope this could add a little clarity.

 

Best Regards,

 

C.S.N. Raja

@RajaCSN, Correct, and that's why I accepted @Ritaf1983's answer as the solution.

Perfect.

Ritaf1983
Super User
Super User

Hi @y5famfnatudu 
Yes. Just turn the option of "keep all filters" to "off"
And remove the filter that you don't need

Ritaf1983_0-1683687593602.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Thank you @Ritaf1983 . The problem is, this filter/slicer is not added initially to the drill-through page. Rather it's passed from a slicer that exists on the other page. And I don't want to remove ALL the filters/slicers passed, rather just one.

@y5famfnatudu 
it sounds that you need to cancel slicecrs sync

Ritaf1983_0-1683688925227.png

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

@Ritaf1983 
I'm not syncing these slicers with the drill-through pages at all.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.