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.
I wish to have a slicer background change colour to make it really obvious when there is a slicer value selected. I have created the measure:
Slicer Color 2 =
IF(
ISFILTERED ('ITRDB Daily_Projects_NonConfidential'[ProjectStatus]), "#AEB6BF", "#FFFFFF"
)
I then apply conditional format for the slicer background using the measure above.
However, the background of the slicer never changes. I have tested the same condition using the same measure on a card visual and it works perfectly. Anybody have any experience/thoughts?
Solved! Go to Solution.
Thanks @amitchandak . I've opted simply to put a conditionally formatted shape behind the slicer to achieve a similar effect. This works.
This is painful. 1700 views later. I wonder if using the value from the slicer to feed the conditional coloring cannot be evaluated on itself?
I believe its futile, because the slicer does not recognise row context on itself, so when you choose a value, it cant tell if the selected value of the slicer is filtered or not.
It's a sad state of affairs. File this one under pure neglect.
Two years later and this issue (and it's a pretty important issue) hasn't been addressed in the slightest. Rather disappointing.
The filter pane changes colour when you select and item, why can't we have the same functionality with slicers? Is there anyone here that is interested in the User Experience? No?...
...Just us then
@vgeldbr , I remember I logged an issue for this in past. If you trying to set color for the slicer for which you are filtering it will not work.
@amitchandak: Creating a shape with formatted background for each slicer is a pain - did you ever recieve a response on your loggin? Regards, Henrik
Thanks @amitchandak . I've opted simply to put a conditionally formatted shape behind the slicer to achieve a similar effect. This works.
User | Count |
---|---|
92 | |
86 | |
67 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |