Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
@barwe There's one way to do it:
http://www.informationmagician.com/shaded-area-between-two-lines/
@barwe There's one way to do it:
http://www.informationmagician.com/shaded-area-between-two-lines/
Wow, okey, thats the better way 😄
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 🙂
@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.
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |