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.
@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 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.
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
