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
Hi 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
I added the SlicerCheck to a test card to confirm it was picking up the slicer correctly and it shows a Y when sliced and N when not sliced. (which is great!). When I add the SlicerCheck to my other card (the one I actually need it to work on), I am adding it to the visual level filters area, it doesn't give me options to filter by. I can click the arrow to expand but I can't type in the contains box underneath.
this works on isolated card
SlicerCheck = if(calculate(distinctcount('DataSet'[Analyst]),allselected('DataSet'[Analyst]))=1,"Y","N")
My slicer is just a list of analyst names 'Dataset'[Analyst]
Please help me find out why the filtering isn't allowing me to click on anything. *if the funcationality isn't there for filter a card's visual then it shouldn't have the option to add there.
Can a KPI be used for this same purpose? Do it allow for the visual filter to be entered?
joshcomputer1 are you able to solve that problem. I am facing the same problem. I need to show the text of selected name from the slicer on the card. Otherwise slicer should be hidden.But I am not able to add the filter on the card visual.