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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous - Sorry, having trouble following, not sure you can hide the entire visual without using a Bookmark ?

  • 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())