Shaded line graph with max and min values

[Anonymous]

Hi Expert

I am trying to figure out how to make a graph like the one below in PowerBI. I can do this in excel fairly easily but cant seem to figure it out in PowerBI. Has anyone done this? Any guidance the group can share? Im completely stumped on this one. 

The shaded area should be the Min/Max and then be able to have line graphs within it that show current years progress.

[v-yuta-msft · Accepted solution]

@Anonymous ,

There's no similar built-in chart in power bi, but as a workaround, you may try basic area chart:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-basic-area-chart

Community Support Team _ Jimmy Tao

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

[technolog · Accepted solution]

@barwe There's one way to do it:

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

 

[barwe]

Wow, okey, thats the better way 😄 

[barwe]

There is a simple solution:

You need 2 visuals. "Area Chart" and "Line Chart"

just color max line area as area between max, min. And min area as background. 

It's not the most elegant solution in the world but it works 🙂 

[v-yuta-msft · Accepted solution]

@Anonymous ,

There's no similar built-in chart in power bi, but as a workaround, you may try basic area chart:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-basic-area-chart

Community Support Team _ Jimmy Tao

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