Forum Discussion
Multi Selected Filter showing more values that it should
Hi Anonymous
Whatever you select in one field would filter what is against it in the other field, based on your thing, I think you can make a concatenated column say ex office-factory , office, factory in one column and whenever you select anything from this concatenated column the results would pop out based on your expectation.
Please mark this as solution if you think this can solve your problem buddy.
The issue with this is we have up to 10 different location types and some locations have up to 5 types. Would make the filter not user friendly.
What about giving a same slicer and dragging one field over the other. Have you tried thay?
Not sure I get what you mean.
I get what you are going for but I dont think this would work. If I was to select "Office" in a filter then it would display all office locations. If I selected both "Office" and "Factory" it should show all locations that have an "Office" and "Factory" on-site. With your proposed filter idea there would be now way to anticipate what combination I am selecting once 5+ location types get thrown into the mix.