Forum Discussion
Line chart with different colours
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 ?
3 Replies
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
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.
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.
