Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Chart Visibility.

Hi Team, I have a requirement that to hide/blank a visual from the page when i select a value from the slicer. By default i want to display the visual in the dashboard. I used IF(ISFILTERED(Table(...
Need Help
Show and Tell
  • Gordonlilj's avatar
    Gordonlilj
    7 years ago

    Hi,

    Try creating this measure

     

    Filter = IF(CALCULATE(DISTINCTCOUNT(Table[Column]),ALLSELECTED(Table[Column]))=1,1,2)

    And insert it into your the visual filter and set it to is 2 and see if that works

     

Gordonlilj's avatar
Gordonlilj
Solution Sage
7 years ago

Hi,

Try creating this measure

 

Filter = IF(CALCULATE(DISTINCTCOUNT(Table[Column]),ALLSELECTED(Table[Column]))=1,1,2)

And insert it into your the visual filter and set it to is 2 and see if that works

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you Gordonlilj ,Working.