Forum Discussion
Dynamically Change Line Colors Based on a Threshold
Hello Kedar_Pande
Check out the below article
https://medium.com/@simon.harrison_Select_Distinct/conditional-format-a-line-chart-in-power-bi-61e25a70e431
Thanks & Regards...To achieve dynamically formatted color changes on a line chart (markers only) you can use conditional formatting on the markers. But, this requires initially creating a bar chart with conditional formatting and then changing it to a line chart. Or else you can try multiple measure approach.
check this thread - https://community.fabric.microsoft.com/t5/Desktop/Line-Chart-Conditional-Formatting/m-p/375161
Hi Kedar_Pande
Currently Power BI's line charts do not support dynamic color changes based on thresholds on a single line.
As BIswajit_Das and Arul mentioned in their replies, it is currently possible to have a conditionally formatted bar chart and then change it to a line chart to achieve a similar effect.
If this alternative is helpful to you, please consider accepting their replies as a solution.
Or you can submit an idea at ideas.
Thank you for your understanding.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I’ve already tried the bar chart workaround, but I need an exact solution to display the dynamic color changes based on thresholds on a single line.
