Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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())
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |