Forum Discussion
Visualisations blank until something selected in a slicer
Hi Dave0145,
For your requirement, you can create a measure like this:
SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allsel
ected([SlicerColumn]))=1,"Y","N") Then place this measure in a table visual, set filter condition as is Y. If you want to select multiple values in a slicer, set is N.
For more information, see:
visual filter problem--unpredictable behavior
Best Regards,
Qiuyun Yu
Community SupportHi Dave0145,
For your requirement, you can create a measure like this:
SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allsel
Then place this measure in a table visual, set filter condition as is Y. If you want to select multiple values in a slicer, set is N.
For more information, see:
visual filter problem--unpredictable behavior
Best Regards,
Qiuyun Yu
v-qiuyu-msft - great solution, thanks! +1
I did note that if you bring the measure onto a table as a column, then the calculation slows down considerably, so best to have it only on the visual level filter.
I noted also that you can't have it on the Page level or Report level filter, but you can of course drag it onto the visual level filter for other tables.
- AnetaK
Helper V
Hello,
I've used this solution to hide a claster column chart and it works.
I've also tried to hide a card with text inside but the visual filter is not working, I can't choose anything, it's blocked.
Can anybody suggest what can be done in that situation?
Is it impossible to use a measure-filter in a card?
What I want to achieve?
I want the card to be invisible until a room on a visual is chosen.
