Reg: Color coding in Straight Table based on condition for complete row/data

[lakshmanvepuri]

Hi All,

I have the scenario like this.  Based on the data: the color of the complete row to show like this.

KN_VAL is a measure and the coding as below.

KN_VAL	COLOR code
<1.0	RED
1.0<X<1.4	YELLOW
1.4<X<1.8	BLUE
1.8<X<5.0	GREEN
5.0<X<999	ORANGE

OUTPUT should be like this.

can any one help me how to achieve this.

Thanks a lot.

Lakshmana

[jagan · Accepted solution]

HI,

Try like this

If(KN_VAL<1.0, Red(),

If(KN_VAL>=1.0 and KN_VAL<1.4, Yellow(),

If(KN_VAL>=1.4 and KN_VAL<1.8, LightBlue(),I

f(KN_VAL>=1.7 and KN_VAL<5.0, LightGreen(),

RGB(265,165,0)))))

Note: You have to give this Color expression for all the dimensions and expressions.

Regards,

Jagan.

[lakshmanvepuri]

Hi jagan,

I implemented the above way only, I would like to check Is there any alternative way to with out giving the expression to all the dimensions.

Thanks

Lakshmana

[Chanty4u]

u can use custom format cell.. 

[jagan]

Hi Lakshman,

There is no other way if you want to have 5 different color codes, this is the best method and it works in all charts.

You can use Visual Clues option but you can give only two colors and available only for Pivot and Straight tables.

Regards,

Jagan.

[lakshmanvepuri]

Thank you very much jagan‌ for giving the solution.