How to color line chart in power bi

[Anonymous]

Hello All,

I have a line and stacked column chart where I am showing sales in bar and porfit in line and I need to color the line based on profit.

Is it possible in Power Bi ?

Could any one please help

[PaulDBrown]

Can you provide sample data and a depiction of the expected outcome?

[Anonymous]

Hi @PaulDBrown ,

Below is my sample data

Date               Sales        Profit

1/1/2021	100	10
1/2/2021	200	20
1/3/2021	300	30
1/4/2021	400	40
1/5/2021	500	50

I took a line and clisutered column and chart and put sales column values and porfit in line values.

Now I need chnage the color of the line for each date based on the porfit values.

if profit is lesstahan 30 then itb should be red else green

[PC2790 · Accepted solution]

Hey @Anonymous ,

I found this interesting thread that states a way of formatting the line according to conditions. You can see if it works out for you.

I even tried it using my data and it is working for me to some extent.

[v-easonf-msft]

Hi, @PC2790 

You appear to be plotting the original line chart in two parts with different colors, right?

greater than 30 = IF(CALCULATE(SUM('Table'[value]))>=30,CALCULATE(SUM('Table'[Sales])),BLANK())

less than 30 = IF(CALCULATE(SUM('Table'[value]))<30,CALCULATE(SUM('Table'[Sales])),BLANK())

Surprised, didn't expect to achieve the same effect without conditional formatting.

I have learned a lot. Thanks for your sharing.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi, @Anonymous 

You can do the same for other graphs like bar and column chart.

However, it is not possible in line chart. You can't set multiple colors for a line chart. A line chart can only correspond to one color. Conditional formatting doesn't work here either.

But you can add a constant line to ‘Line Values’ to facilitate analyzing the data.

constant line= 30

Best Regards,
Community Support Team _ Eason