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.

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

    Sorry I need more detail than this, the two visuals I want to make blank are Customer and Address visual, taken from CustomerDim, AddressDim as highlighted in my post. There are no measures/calculations in these two visuals. Where do I create this 'isfiltered' measure in Customer and Address? Please provide steps. Thanks.