This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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.
Solved! Go to Solution.
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
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
Thank you Gordonlilj ,Working.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 25 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 65 | |
| 41 | |
| 28 | |
| 22 | |
| 22 |