Change the color of line in line and clustered column chart

[jesly_ajin]

I have the graph as below, the Revenue is the bar and Gross Margin as line. I need the color of the line to be red for negative values and green for positive values. Please help as i am completely new to this.

[dax · Accepted solution]

Hi jesly_ajin,

As  I know, there is no conditional format for line in line and clustered column chart. You could try to put field which have negative value in column

Or another workaround is that you could create another measure for this

Measure 2 = if(SUM('Table'[q2])>0, SUM('Table'[q2]), BLANK())

By the way, you could submit this requirement in power-bi-ideas

Best Regards,

Zoe Zhi

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

[jesly_ajin]

@dax 

As shown in your 2nd image i need it continuous line.

I tried the same now, but i am getting another line in the graph instead of continuous line.

[dax]

Hi

What is your measure? You might need to try below  measure

Measure 2 = if([GP]>0, [GP]), BLANK())

Or you could try to upload your sample data  or pbix file, I will help you more correctly

Best Regards,
Zoe Zhi

[jesly_ajin]

@dax 

Thanks a lot for the solution.

Works good after a refresh.