Forum Discussion
Anonymous
7 years agoNot applicable
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
- GordonliljSolution Sage
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
- AnonymousNot applicable
Thank you Gordonlilj ,Working.