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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Greg_Deckler ,

Apologies for the confusion.

I have a Slicer, filters on Account. If I select one Account, the Visual should Display but if Selected MultiValue in Slicer the Visual should Hide. Im trying to Acheive this requirement, unfortunately Im not able to do.

 

Regards

Chandra

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous I believe:

New Measure = IF(HASONEVALUE('Table'[Account]),[Old Measure],BLANK())