Forum Discussion
Color code Multiple lines in a single chart
- 4 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.
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.