cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Conditional Formatting of One Column based on value of Other Column - SAP Lumira Designer

0 Kudos

Hi Gurus,

Currently i have a requirement for Conditional Formatting of a One Column based on the value of other Column of a Column Chart.

For example, see below chart. In below chart, let's say Column1 = Actual and Column2 = Target. Following is the expected result.

Case 1: (Value of Column1 > Value of Column2 ) then Color of Column1 = 'RED'

Case 2: (Value of Column1 = Value of Column2 ) then Color of Column1 = 'YELLOW'

Case 3: (Value of Column1 < Value of Column2 ) then Color of Column1 = 'GREEN'

I tried below code and its ending up coloring both the bars as RED. I just want Bar1(Column1) as RED.

.colOverview g.v-m-main g.v-m-plot g.v-plot-main g.v-datapoint-group .v-datapoint:nth-child(2) rect { fill: red !important; }

Would appreciate, if anyone of you could help in getting the right result.

Note:

1) For now, i'm hardcoding the Color for Column1, but once i'm able to apply color individually to each BAR, then i would write script to dynamically change the color of Column1 based on Column2 value.

2) I already know about ChartPlus Add-on for Designer. But for now, our organization is not looking at having paid add-on for lumira. Therefore trying through CSS route.

Regards,

Shujaath

0 Kudos

Hi Gurus,

Any help?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member767826
Discoverer
0 Kudos

Hi,

Did you find the solution for this?If yes Please help me i am also facing same issue now.