March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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.
I have the same problem, someone manage to solve?
Good morning, I have the same problem, did anyone manage to fix it?
Thanks a lot
@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/
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
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.
Hey Duke, how are you? were you able to solve it? I'm having the same problem.
Best regards
@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.
@Anonymous Not sure I 100% understand. Make sure that your filters are filtering one another via Edit Interactions.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |