Forum Discussion

yodha's avatar
yodha
Helper IV
7 years ago
Solved

Conditional formatting using slicer

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 ...
  • parry2k's avatar
    parry2k
    7 years ago

    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

parry2k's avatar
parry2k
Super User
7 years ago

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's avatar
    yodha
    Helper IV
    7 years ago

    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