Line chart: Many color for the same line

[Testy]

Hello everyone,

I’d like to know if any of you have found a way to change the color of a line chart based on its values.

Here a picutre of what I'm trying to achieve:

The color change depending of the value
Higer than 3, it should be green
Between 3 and 2.5 yellow
Between 2.5  and 2 orange
And lower than 2 red

Any idea of how can I achieve that?

Many thanks in advance for your help 🙂

[SamWiseOwl · Accepted solution]

Hi @Testy 

The quick solution is:
Create a column chart of your visual.

Make a new measure with your conditions:

Colour Measure =

SWITCH(

    TRUE()

    ,sum(Sales[Quantity]) > 1500 , "Green"

    ,sum(Sales[Quantity]) > 1000 , "Yellow"

    ,"Red"

)

Assign this to your Column's colour.

Convert that column chart into a line chart.

Hope this helps!

The other option is create three seperate measure to show the lines and format them different colurs.

Only issue with that is getting the lines continius

[v-xinruzhu-msft]

Hi @Testy 

Did the solution @Kedar_Pande  and @SamWiseOwl  offered help you solve the problm, if they helps, you can consider to accept them as solutions so that more user can refet to.

Best Regards!

Yolo Zhu

[Kedar_Pande · Accepted solution]

Create a New Measure for Each Color Band

GreenValues = IF( [YourMeasure] > 3, [YourMeasure], BLANK() )

YellowValues = IF( [YourMeasure] <= 3 && [YourMeasure] > 2.5, [YourMeasure], BLANK() )

Similarly create for others....

Drag each of the newly created measures on Y axis. In the Visualizations Pane, go to Format.
Under Data Colors, assign green to GreenValues, yellow to YellowValues, orange to OrangeValues, and red to RedValues.

If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[SamWiseOwl · Accepted solution]

Hi @Testy 

The quick solution is:
Create a column chart of your visual.

Make a new measure with your conditions:

Colour Measure =

SWITCH(

    TRUE()

    ,sum(Sales[Quantity]) > 1500 , "Green"

    ,sum(Sales[Quantity]) > 1000 , "Yellow"

    ,"Red"

)

Assign this to your Column's colour.

Convert that column chart into a line chart.

Hope this helps!

The other option is create three seperate measure to show the lines and format them different colurs.

Only issue with that is getting the lines continius