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.

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

We can set condiftional formamting in backgroud pane like the picture as below.

 

 

Or you should add the banner column to the table visual as well to set condiftional formatting as the way you used before.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-frfei-msft  ,

Thanks for your time.

 

However, I am trying to add the Conditional Formatting in background pane to a Slicer Visual, not a table.

Can you please try that for me and let me know if it works on your side?

 

Cheers,
Robin

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    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.