Line chart with different colours

[Jeremy19]

Hi,

It is possible to have a line that changes color according to a categorical variable? I have 3 columns (Time, Value and TeamId). I wish to have the line which is the color of the team at this time. The problem is that when I put TeamId in legend it creates two curves, one for each team like the image below

Any ideas ?

[Anonymous]

Hi @Jeremy19 ,

Currently Power BI does not support this feature, you can raise a new idea and add your comments there to make this feature coming sooner. Or you can refer the solution in the following thread as workaround.

Line Chart: Conditional Formatting

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[Jeremy19]

Nice tip but it doesn't give exactly what I want. It displays the markers that I cannot remove and the curve remains only blue. In fact, the line should keep the color of the previous point.

[mahoneypat]

You can make a measure like this that you can use as the data color.

Line Color = SWITCH(MIN(Table[TeamID]), "Team A", "Red", "Team B", "Blue", "Black")

Then here's the trick that Reid Havens has a video about here - https://www.youtube.com/watch?v=2_2rGxA6PKQ

First make it a bar chart, use this measure in the fx button for the data color, then switch the chart to a line chart.  The line chart by default doesn't have the option to use a color measure but this is a workaround.

Regards,

Pat