Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Answers'[Banner] ) , 1, BLANK() )
As you can see above my Slicer Formatting measure has value 1 which is supposed to change the background of my slicer to Red, but nothing is happenning...
Is there something I'm doing wrong?
Thanks in advance,
Rob
Solved! Go to Solution.
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.
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?
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |