Change data slicer background color if any values (instead of all) is selected

[JK_PBI]

Hi,

I am using the default standard data slicer on my report. I have a request from user to change data slicer background color if one or more values of slicer (instead of all) is selected.  I thought slicer's visual background conditional formatting can do the magic but unfortunately it doesn't.  It seems when slicer data is selected, the selection does not apply to slicer itself.

Does anyone have any workaround?  Thanks in advance;

[parry2k · Accepted solution]

@JK_PBI although there is a hack (work around) to achieve this:

- add a shape and set the background of this based on the measure given below

- make sure this shape is under the slicer

- turn off background color under size and style on format pane of slicer (see below)

here is the measure you can use to set the background color of the shape:

Color = 
VAR __TotalCount = COUNTROWS ( ALL ( Orders[City] ) )
VAR __SelectedCount = COUNTROWS ( ALLSELECTED ( Orders[City] ) )
RETURN
IF ( __TotalCount <> __SelectedCount, "Red" )  --set the color hex code here I just set it to red for demo

and here is the outcome:

[JK_PBI]

Thank you for the workaround. Appreciate!

[parry2k]

@JK_PBI at this point you cannot set the background color dynamically, in other words, it is not possible for now.

[JK_PBI]

@Ritaf1983  thanks for the response.

This is what I am after:

For this Week Slicer,  if all options are selected,  no backgrund colour (white)

if one or more values are selected, show background in red color

[Ritaf1983]

Hi @JK_PBI 
@parry2k suggested great solution 🙂

[Ritaf1983]

Hi @JK_PBI 
Can you please show the screenshot with the desired result?