Forum Discussion
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 line .(star,rectangle and square)
Now my requirement is I need to change my 3 line colors based on nps score.
So if nps is morethan 90 it should be green and lessthan 90 it should be red.
is it possble ?
Could anyone please suggest how to do this for all 3 lines in the chart.
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.
4 Replies
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?
Hi danextian ,
Below is screenshot with sample data.
I dont see conditional color coding option for the lines
Apologies. I've realized that conditional formatting of lines in a line chart is not currently supported. Only the markers can be and there shouldn't be a legend. You can vote for that idea here:
https://ideas.powerbi.com/ideas/idea/?ideaid=ca2bb8a9-9af6-eb11-ba5e-281878bd73ba
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.
