Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
u can use custom format cell..
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.
Thank you very much jagan for giving the solution.