Forum Discussion

sagittarius_111's avatar
sagittarius_111
Frequent Visitor
1 year ago
Solved

Slicer

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's avatar
    Anonymous
    1 year ago

    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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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