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
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.

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Greg_Deckler
Super User
Super User

@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!:
Power BI Cookbook Third Edition (Color)

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
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.