Line Graph Modifications in Power BI

[Anonymous]

I use the below line graph in my report. My customer is looking for the line color changes when it is above 2.5 value. The above values should be in green and the below values should be in red.

How this can be achieved ?

[v-alq-msft]

Hi, @Anonymous 

Unfortunately, it is unsupported to conditional format line chart in Power BI currently. I'd like to suggest you vote on the similar idea and add your comments there to improve Power BI for making this feature coming sooner.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Not possible. You can show marker, That only when you are using only one line and no legend

Create color measure 

color = if([Measure] >2.5 , "red", "green")

Then use this in conditional formatting using the field value option. Create a Bar visual then do conditional formatting , convert to line with markers. The marker will be in color

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values