Solved: Conditional formatting using slicer

yodha · ‎07-17-2019

i have a table like this,

and i did conditional formatting for "Test Measure" row like this,

now i have to add a slicer for "test measure", based on slicer value selection back ground color should change. can we achieve this functionality, thanks in advance.

parry2k · ‎07-17-2019

@yodha you can use "Field Value" instead of "Rules" in format by option. Field Value is something you can select as a measure to create the colors:

For example:

My Color = 
VAR __slicerValue = SELECTEDVALUE( Table[SlicerColoumn[ )
RETURN
SWITHC( TRUE(),
__slicerValue > 100, "Red",
__slicerValue > 50, "Yellow",
"Green"
)

And in Field you can chose "My Color" measure which will drive the logic for color.

Hope it helps

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎07-17-2019

@yodha you can use "Field Value" instead of "Rules" in format by option. Field Value is something you can select as a measure to create the colors:

For example:

My Color = 
VAR __slicerValue = SELECTEDVALUE( Table[SlicerColoumn[ )
RETURN
SWITHC( TRUE(),
__slicerValue > 100, "Red",
__slicerValue > 50, "Yellow",
"Green"
)

And in Field you can chose "My Color" measure which will drive the logic for color.

Hope it helps

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

yodha · ‎07-25-2019

Hi,

Thanks for the reply, it really helped me, now am able to achieve this functionlity in my report.

thanks once again.

@parry2k wrote:
@yodhayou can use "Field Value" instead of "Rules" in format by option. Field Value is something you can select as a measure to create the colors:

For example:
My Color = 
VAR __slicerValue = SELECTEDVALUE( Table[SlicerColoumn[ )
RETURN
SWITHC( TRUE(),
__slicerValue > 100, "Red",
__slicerValue > 50, "Yellow",
"Green"
)
And in Field you can chose "My Color" measure which will drive the logic for color.

Hope it helps

Conditional formatting using slicer

Helpful resources

Power BI Monthly Update - April 2024