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.

     

     

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.