Forum Discussion
Line and stacked area graph
Help, please!
I have the following columns in a table: Date, Electricity bill (let`s call it A), Adjusted electricity bill (let`s call it B), and Savings (B-A, let`s call it C).
How could I create a graph that displays lines as above for A and B, and have the bit in between (C) stacked) or highlighed, like below:
Date is in date format, the other three (A, B, C) are Decimal values.
Thank you.
I have created a tutorial for you to achieve this using the native visual in Power Bi do check it out and let me know if this helps !!
How to Create Shaded Areas Between lines in a Line Chart in Power BI | MiTutorials - YouTube
Best regards,
Ismail | MiTutorials
Explore over 200+ Power BI tutorials and enhance your skills!
Alexandra_B Let us know if the solution helped so that we can accept solution and close the thread.
4 Replies
Hello.
Sorry, I`ve seen the replies too late, I managed to do it with the Error Bars.Thank you everyone for your help!
I have created a tutorial for you to achieve this using the native visual in Power Bi do check it out and let me know if this helps !!
How to Create Shaded Areas Between lines in a Line Chart in Power BI | MiTutorials - YouTube
Best regards,
Ismail | MiTutorials
Explore over 200+ Power BI tutorials and enhance your skills!
Alexandra_B Let us know if the solution helped so that we can accept solution and close the thread.
Hi Alexandra_B ,
Power bi doesn't seem to have a related supported feature, but can give you a kind of workaround where you can calculate the difference to present it on a chart.
Measure = SUM('Table'[Item1])-SUM('Table'[Item2])Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
