Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Color code Multiple lines in a single chart

Hello All,   I have a chart where I am showing my NPS for 3 locations with multiple lines in a single line chart. Locations are India,USA and Canada So I am using diffeent shapes here for each li...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    3 years ago

    Hi Anonymous ,

     

    For the line chart, each line can only display one color (which can be customized), but it is not possible to specify the color of a line segment based on a conditional judgment. This is mainly different from legends, which can cause color conflicts. But similar to table visual, you can set the color under different conditions by customizing the condition. Reference as follows.

    M =
IF (
    MAX ( 'Table'[Value] ) > 90,
    "green",
    IF ( MAX ( 'Table'[Value] ) < 90, "red", "yellow" )
)

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

danextian's avatar
danextian
Super User
4 years ago

Hi Anonymous ,

 

That should be possible with conditional formatting. Can you please post a sample data that we can easily manipulate as well as a screenshot of your chart?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi danextian ,

 

Below is screenshot with sample data.

I dont see conditional color coding option for the lines