Shaded portion between two lines (line graph?)

[corodyne]

Hi folks,

I'm looking to create a line graph that has forecasted sales and actual sales, but the area between the two lines are shaded green (we sold more than the forecast) or red (we sold less than the forecast).

I've looked around, but haven't seen a solution to this problem.  Excel does this pretty easily, but has it been ported into PBI, yet?

Thanks,

CJS

[v-caliao-msft · Accepted solution]

@corodyne,

Current;y, we can set data colors for fact sales and forecast sales, and the results looks like on the screenshot below.

If you want to only colour the part sold more than the forecast and sold more than the forecast, I am afraid there is no such a functionally to achieve this requirement. If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

Thank you for your understanding.

Regards,

Charlie Liao

[v-caliao-msft · Accepted solution]

@corodyne,

Current;y, we can set data colors for fact sales and forecast sales, and the results looks like on the screenshot below.

If you want to only colour the part sold more than the forecast and sold more than the forecast, I am afraid there is no such a functionally to achieve this requirement. If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

Thank you for your understanding.

Regards,

Charlie Liao

[technolog · Accepted solution]

@corodyne There's one way to do it:

http://www.informationmagician.com/shaded-area-between-two-lines/

 

[wyatt]

I followed the instructions on the walkthrough, but my shading is going from point to point.  My data is on a monthly level so that could be the cause.  Any tips here?

[technolog]

@wyatt I also tried to fix it but could not😲