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 September 15. Request your voucher.

Reply
Anonymous
Not applicable

Default option or clean selected filters when switching to another filter

Hello

I have a problem. I have a number of unique filters that give rise to a graph. The problem is that when I select for example Place 4 and the next worker ID does not take place 4, the filter gets hooked and I have to change it manually. In the image I explain it better. Is there any way that when I change Worker ID I get the first or only value that the other filters have?
I thought of a marker to clean filters but... it happens the same because if I make the filter that comes from a worker who has type 1 and I switch to one that has type 2, it gets hooked the same. The idea is for it to change. I thought I'd put in the data something like "Not Selected" that's in everyone and have that by default in the filters and with marker that came back there when switching workers. The idea is that it was interactive and changed to where there's data or something. If there are no more solutions than this I will. Thank you very much.

Power Bi.PNG

11 REPLIES 11
Syndicate_Admin
Administrator
Administrator

I have the same problem, someone manage to solve?

Syndicate_Admin
Administrator
Administrator

Good morning, I have the same problem, did anyone manage to fix it?

Thanks a lot

DataZoe
Microsoft Employee
Microsoft Employee

@Anonymous I know the behavior you are describing and it is frustating.

 

An option to deal with is to create a "Reset" button that will clear the filters or take the page back to the default state using a bookmark. The users my opt to do that instead of trying to clear all the filters individually and hopefully avoid the issue.

 

 

 

 

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

Anonymous
Not applicable

Thank you, DataZoe. It's not a solution I like, but it's at least a solution.

The ideal solution would be that filtering would automatically bring all filters to a value that at least exists, not displayed visually if the value does not exist...

Greetings.

Anonymous
Not applicable

Hi @Anonymous ,

Please watch the following videos, hope they can help you resolve the problem.

One Slicer to filter other slicers

Power BI slicers not filtering other slicers?

Best Regards

Rena

Anonymous
Not applicable

Thank you for all the possible solutions but, I think I will try to record a video to clarify well what I mean since it is not solved with anything commented.

Greetings.

Anonymous
Not applicable

Hey Duke, how are you? were you able to solve it? I'm having the same problem.

Best regards

amitchandak
Super User
Super User

@Anonymous , Think this is there for a while if the value is selected and other slicers remove that value it shows as selected.  But page reflect correct value.

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
Greg_Deckler
Community Champion
Community Champion

@Anonymous Not sure I 100% understand. Make sure that your filters are filtering one another via Edit Interactions. 



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!:
DAX For Humans

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

Hello
Maybe I haven't explained myself well. Interactions are not resolved.

I have a juan worker who has a place 4 (in addition to 1, 2 and 3), I select it in the filter place 4, I switch to Toni that does not take place 4 (but yes 1, 2 and 3) but the 4 is selected because I have selected John and in fact if I deploy places I will see 1, 2, 3 and 4. I don't know if I don't see Toni's graph because there's a problem or because it doesn't take place 4, in fact when I press on Toni place 3, now in the drop-down I'll see 1, 2 and 3, the 4 will have logically disappeared because it's never had it and it showed up because it got hooked from John.

I hope I've cleared it up. I can make a video to explain myself better.

Thank you so much.

Hello @Duque , if you still can't solve this problem, check if the "Cross Filter Address" option in your table relationships selects the "Both" option.

Best regards.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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