Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Line chart: Many color for the same line

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 🙂

 

Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    Hi Anonymous 

    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

     

  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    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

3 Replies

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    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's avatar
    SamWiseOwl
    Super User
    1 year ago

    Hi Anonymous 

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous 

    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