Change Line Chart Color based on the values

[sathiyen]

Hi I have Line chart which shows sales on each day, Now I need to differntiate the difference, 

If the sales value is lesser than the previous day (Where the line goes down) it should be in red.

If the sales value is greater than the previous day (Where the line goes up) it should be green.

Any options to do it, or is there any work around?

Thanks in Advance.

[v-xuding-msft]

Hi @sathiyen ,

It is not supported for now. To make Power BI better, you can submit your request at Power BI Ideas and vote it up.

For the workaround, I have made a test that you could create two measures to get the result below.

Last = CALCULATE(SUM('Table 1'[Sales]),FILTER(ALL('Table 1'),'Table 1'[Date] = MAX('Table 1'[Date])-1))
Current = IF(SUM('Table 1'[Sales]) < 'Table 1'[Last], SUM('Table 1'[Sales]),BLANK())

Best Regards,

Xue

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

[sathiyen]

@Xue, 

Thanks For your effort and time.

But my requirement is different, I need to highlight on the same legend, I have found a work around for it which is working partially, will update you once I get the complete solution.

Thanks

Sathiyen

[v-xuding-msft]

Hi @sathiyen ,

Could you tell me if your problem has been solved?  It is kind to share your own solution. More people will benefit from here.

Best Regards,

Xue

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

[sathiyen]

Hi Xue,

I didnt get the solution, still working/searching for it. Will post if I get it for sure. There are lot of people who voted for this idea, hope Microsoft will update it soon.