Slicer

[sagittarius_111]

we have two field parameters slicer in Power BI having same values, client wants to implement the functionality where if he selects one value from slicer 1 then same value should not be visible in slicer 2 and he should be able to select rest of values. How can we implement this

[Anonymous · Accepted solution]

Hi @sagittarius_111 ,

Unfortunately, this is unlikely to happen. You can try to think of it as two separate tables created by field parameters, which are not related to each other.

You can try creating a relationship between the two field parameters to see if that meets your requirements.

After the relationship created, here's the example.

You can remove blank by filtering out it in the filter.

Then when you select Name in Parameter 2 slicer, it will only display Name in Parameter because of the realtionship.

Best Regards,
Stephen Tao

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