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.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,Based on what I got

Hide visualization means you are making content blank. Because the other option is the bookmark button. I doubt that will help in this case,

The date should have date datatype. Not sure why text. You should able to change the data type in column tools for most of the databases in direct query.

The date is DD-MM-YYYY format that needs a setting to work as date. Hope that is in place.

 

try Something like this

measure =

var _sel = countroes(allselected(Table[field]))

return

if(_sel >2, [measure], blank())