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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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