Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Hide Visual

Hello All, I have the Below Visualization, which is based on Direct Query. The data is based on Slicer. If I select multivalues in the Slicer the Visualization should be Hidden else it should...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    You can create a measure and add it to the filter on the visual.

    __Filter = 
VAR x =
COUNTAX(
    ALLSELECTED(Sale),
    [Customer_ID]
)
RETURN
IF(
    x = 1,
    1, 0
)

     

    Best regards,
    Lionel Chen

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

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

You can create a measure and add it to the filter on the visual.

__Filter = 
VAR x =
COUNTAX(
    ALLSELECTED(Sale),
    [Customer_ID]
)
RETURN
IF(
    x = 1,
    1, 0
)

 

Best regards,
Lionel Chen

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