Line chart with shaded area?

[OneWithQuestion]

I would like to make a chart like this:

Where there is a shaded goal area, and then a line.

The goal area is NOT hard coded, it needs to be set be mapped against a measure.  In the above example the goal line happend to be static, but it could change over time.

Any suggestions?  Thanks!

EDIT:

This is the closest I could come, but I would really like to be able to format the shading to drop that from the second measure:

That redish pink area would work better as a LINE not a shaded area.

[technolog]

 There's one way to do it:

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

@OneWithQuestion

[ashako88]

 In case someone is still looking for this option, it's one of the updated versions in 2021 (not sure which one). Allows you to pick which line to shade under.

[Seth_C_Bauer]

@OneWithQuestion This would be a good formatting option to have in the Area Chart for sure... to be able disable some of the shades in the lines to use a goal line measure. Other than your idea below, the only other thing I could come up with is to use a "line and stacked column chart" - but this produces gaps and is visually distracting. I tried a bunch of different overlays and tricks, but the x-axis isn't constant and it won't align well in overlap correctly as the goal changes. 😞

[OneWithQuestion]

Yeah, I tried that too and ran into issues with bar gaps that I know would really distract and confuse the users so... I just gave up on that 😞

I did post a question about anyway to hide gap though.

[v-caliao-msft]

Hi @OneWithQuestion,

I have tested it on my local environment using the sample data below.

We can get the expected result like below.

Regards,

Charlie Liao

[pdi]

Hi @v-caliao-msft,

Thanks for this solution. How did you get the Difference series to start at 1000?

Thanks much !

[pdi]

@v-caliao-msft Don't worry - got it ! Stacked area-chart.... 

[OneWithQuestion]

Sadly, that still shows a shaded area under the line.

Ideally one would be a line and the other would be a shaded area (or column bar chart with adjusted gap width)

[v-caliao-msft]

Hi @OneWithQuestion,

Currently, this the closest workaround we can achieve in Power BI, if this is not what you want, you can create a custom visual to achieve it if you have rich experience in coding.

Regards,

Charlie Liao