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(column Name),1,0) but its not working.

 

Note : Both the slicer and visual axis column are same from the same table.

 

Regards,

Suresh.

  • 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

     

2 Replies

  • 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

      Thank you Gordonlilj ,Working.