Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Just blank your measure when there is more than one value selected...
IF(HASONEVALUE(yourslicer[column]), measure, BLANK())
Thanks lukiz84, this has inspired me to find a solution 🙂
Just blank your measure when there is more than one value selected...
IF(HASONEVALUE(yourslicer[column]), measure, BLANK())