Line graph with two colors based on a paramether value????

[Krlos5411]

Hello experts,

Quick question if anyone knows that is possible.

I have a line graph with weekly values, those values depends of the data that is updated weekly.

And I have a paramether that can be manually modified by the user. But this value is used only to have a minimun a acceptable value.

There's a way where I can change the color of the weekly values that came from databricks, base on the value of the paramether?

Above green and below red, like this:

[v-kathullac]

Hi @Krlos5411 ,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @Krlos5411 ,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

Chaithanya.

[freginier]

Hey there!

You could try creating a measure for conditional coloring. Like this: 

Line_Color =
VAR Threshold = SELECTEDVALUE(ParameterTable[ParameterValue])
VAR CurrentValue = SELECTEDVALUE(YourData[WeeklyValue])

RETURN
IF(CurrentValue >= Threshold, "Green", "Red")

-------Replace ParameterTable[ParameterValue] with the actual parameter table column.
-------Replace YourData[WeeklyValue] with your dataset's weekly values.

And then apply conditional formatting in the line chart. :

- Select the line graph.
- Click on the Format pane (paint roller icon).
- Go to the Data Colors section.
-Click on the fx (conditional formatting) next to the line color.
-Choose "Based on field", then select the Line_Color measure.

With this, when the weekly value is above the parameter → Line turns green.
When the weekly value is below the parameter → Line turns red.

Hope this helps!

😁😁
Set "Green" to one color (e.g., Green) and "Red" to another (e.g., Red).

[Krlos5411]

Thansk for the guide.

I think I got all correct. But I don't have the fx button next to the line color option

[kushanNa]

Hi ,

I'm not sure you can achive this using one line , you will need two lines for this one for green and the other for red

steps to get the above result 

1. create two mesure for green and red 

RedLineMeasure = 
VAR Threshold = SELECTEDVALUE(ParameterTable[ParameterValue])
VAR AvgLeadTime = AVERAGEX(
    YourData,
    DATEDIFF(YourData[LeadTime_Date], YourData[Date], DAY)
)
RETURN
IF(AvgLeadTime <= Threshold, AvgLeadTime, BLANK())

GreenLineMeasure = 
VAR Threshold = SELECTEDVALUE(ParameterTable[ParameterValue])
VAR AvgLeadTime = AVERAGEX(
    YourData,
    DATEDIFF(YourData[LeadTime_Date], YourData[Date], DAY)
)
RETURN
IF(AvgLeadTime >= Threshold, AvgLeadTime, BLANK())

2.  add the following values to line chart 

3. and color code each lines , i have shown in here green as an example