formating based on only single value selected in slicer

[Anonymous]

Hi helpfull community,

in my report I have a graph that by default plots data for all points in the data base but is useless as such (by design).

It becomes usefull if a certain slicer has been used to filter down to a single value.

My idea now is to hide the plot in all cases that more than one value has been slected in the slicer.

This could probably be done by an overlay that becomes transparent when only a single value for the slicer is slected?

But how? Or are there other ideas?

Thanks,

Torge

[Anonymous]

Thanks lukiz84, this has inspired me to find a solution 🙂

[lukiz84 · Accepted solution]

Just blank your measure when there is more than one value selected...

IF(HASONEVALUE(yourslicer[column]), measure, BLANK())