Forum Discussion

jhowe1's avatar
jhowe1
Icon for Helper III rankHelper III
5 years ago
Solved

If slicer not selected blank visual

Hi all,   I have two multi-row card visuals which i want to show blank if nothing is selected in slicer. I've noticed a bunch of people have asked the same thing, (why can we not have conditional v...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi jhowe1 ,

     

    Please use the following formula to create a measure 

    Measure = IF(ISFILTERED('Table'[ID]),1,0)

    And apply it to filter pane, set as "=1" like this:

     

    Best Regards,
    Eyelyn Qin
    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 jhowe1 ,

 

Please use the following formula to create a measure 

Measure = IF(ISFILTERED('Table'[ID]),1,0)

And apply it to filter pane, set as "=1" like this:

 

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

  • jhowe1's avatar
    jhowe1
    Icon for Helper III rankHelper III
    5 years ago

    Finally managed to get back to this, a picture tells a thousand words thank you. A conditional visibility property on the visual would still be nice like we have in SSRS instead of these workaround solutions but works great will do for now.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello, I have the same situation I have State column and If slicer is not selected I want my map to be blank? Thank you in advance.