Conditional formatting using slicer

[yodha]

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 · Accepted solution]

@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

[yodha]

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

---