Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer Selection Conditional Formatting

Hi,   I would like my slicer to change color if one value is filtered.  Below is what I've done so far but the slicer is not changing color...    Slicer formatting = IF( HASONEFILTER( 'Query A...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    To create measures as below and set conditional formatting based on Slicer formatting color.

     

    Slicer formatting = IF( HASONEFILTER( 'Query Answers'[Banner] ) , 2, 0 )
    Slicer formatting color = IF( [Slicer formatting]=2 , "#FF2657", BLANK() )

     

    For more details, please check the pbix as attached.

     

     

Juliecal73's avatar
Juliecal73
Helper III
6 years ago

This does not seem to work for Date Slicers with Relative Dates mode.

I have tried with a bunch of different ways, and the card I use to test changes color, but the Date Slicer never does

I am using the following measure in the Date Slicer Background conditional formatting.

 

#DateFilterColor = 
   IF(
      ISFILTERED('USA AEIOU'[SubmittedDate]),
      "#FF2657",
      "#FFFFFF00"
      )

 

 

 

Thoughts?