Color code Multiple lines in a single chart

[Anonymous]

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.

[v-henryk-mstf · Accepted solution]

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]

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]

Hi @danextian ,

Below is screenshot with sample data.

I dont see conditional color coding option for the lines

[danextian]

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