Line chart: Many color for the same line

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

 

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