Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mmace1
Impactful Individual
Impactful Individual

Change slicer background, if slicer is being utilized - why isn't this working?

I have a measure: 

storeformat = if(ISFILTERED(Transactions[Store]),1,0)

 

Very simple, and it works correctly. 

Yet, I can't seem to use it, to conditionally format the background of a slicer. 

kmCGGwV.png

 

I would think the above would cause the slicer to turn red - but it doesn't.  Why doesn' the above work? 

(The idea being, to highlight any actively-used slicer, so users realize they have a filter on). 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@mmace1 , I tried in the past and logged an issue too, If you trying to change the color of the slicer using the value of the same slicer it did not work.

But it should work for cards.

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@mmace1 , I tried in the past and logged an issue too, If you trying to change the color of the slicer using the value of the same slicer it did not work.

But it should work for cards.

mmace1
Impactful Individual
Impactful Individual

@amitchandak 

Ah, it does work for cards!

That's really disappointing it doesn't work for its own slicer though.  I guess I could put a tiny card on top of each slier (or to the side, or something) to indicate the slicer is being utilized. 


@mmace1 , remove the title. I this in the new version even text box support conditional formatting.

The group with card or text

mmace1
Impactful Individual
Impactful Individual

@amitchandak Thanks. 

I was going to use a card (once I got the text to go away, or be hidden), but a text box works even easier. 

Didn't realize text boxes had such options now. 

workingkinda.PNG

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.