topic Conditional formatting using slicer in DAX Commands and Tips

Conditional formatting using slicer

yodha — Wed, 17 Jul 2019 13:25:53 GMT

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.

Re: Conditional formatting using slicer

parry2k — Thu, 18 Jul 2019 03:10:42 GMT

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

Re: Conditional formatting using slicer

yodha — Thu, 25 Jul 2019 11:51:51 GMT

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