Visual Cue - Max & Min Value

[Anonymous]

Hello to all,

I have a straight table that has some number values with expressions. I want to use the visual cues feature to have the highest value green and the lowest in red. If someone could just help with an expression to do that would be great.

[manojkulkarni]

In the visual cues, select expression and define upper & lower limit to show in respective colors.

eg: if sales margin is less than 5% then indicate in red. Actual expression will be <0.5 in lower limit

[ecolomer]

See this example

[Anonymous]

The values aren't percentages they are just numbers. So if the dimension is sales, what would the actual expression be for Max or Min.

[jagan]

Hi,

Please find attached file for solution.  Used variables and Background Color option of expression to achieve this.

Regards,

Jagan.

[Anonymous]

I don't see an attachment, can you send again please

[jagan]

Hi,

I am able to see the attachment anyway I am attaching it again.

Regards,

Jagan.