cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Visualizing a confidence level interval with an area plot

Hi Everyone!

I would like to have a graph as it is shown below to visualize confidence intervals, but I can't find a way to do this with Power Bi.

I want to have a shade area for this interval instead of lines and when trying to do this using area plots I couldn't see a way to manipulate transparency for each of the lines.

 

Captura de Pantalla 2020-04-17 a la(s) 12.25.18 p. m..png

 

 

 

 

 

 

 

 

 

 

Help is really appreciated!

🙂

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Visualizing a confidence level interval with an area plot

Can you provide sample data to play around with? Looks interesting but not sure there is a solution, although the forcasting feature in Power BI line charts does something very similar...

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: Visualizing a confidence level interval with an area plot

@Greg_Deckler Thanks for your answer! Attached there is a data sample to play with. It contains a date, a variable value and upper and lower bounds.

DateVariableLower BoundUpper Bound
01/01/2018$ 0,37$0,37$0,37
02/01/2018$ 0,50$0,50$0,50
03/01/2018$ 0,76$0,76$0,76
04/01/2018$ 1,23$1,23$1,23
05/01/2018$ 1,63$1,63$1,63
06/01/2018$ 2,40$2,40$2,40
07/01/2018$ 5,50$5,50$5,50
08/01/2018$ 6,20$6,20$6,20
09/01/2018$ 8,87$8,87$8,87
10/01/2018$ 10,66$10,66$10,66
11/01/2018$ 10,97$10,97$10,97
12/01/2018$ 12,50$12,50$12,50
13/01/2018$ 12,60$12,60$12,60
14/01/2018$ 12,90$12,90$12,90
15/01/2018$ 13,27$13,27$13,27
16/01/2018$ 13,77$12,39$15,15
17/01/2018$ 13,87$12,48$15,26
18/01/2018$ 13,90$12,51$15,29
19/01/2018$ 14,20$12,78$15,62
20/01/2018$ 14,39$12,95$15,83
21/01/2018$ 14,50$13,05$15,95
22/01/2018$ 14,76$13,28$16,24
23/01/2018$ 14,84$13,36$16,32
24/01/2018$ 14,86$13,37$16,35
25/01/2018$ 15,14$13,63$16,65
26/01/2018$ 15,30$13,77$16,83
27/01/2018$ 15,46$13,92$17,01
28/01/2018$ 15,63$14,06$17,19
30/01/2018$ 16,96$15,26$18,65
31/01/2018$ 17,14$15,43$18,85
01/02/2018$ 17,32$15,59$19,05
02/02/2018$ 17,50$15,75$19,25
03/02/2018$ 17,68$15,92$19,45
04/02/2018$ 17,87$16,08$19,65
05/02/2018$ 18,05$16,24$19,85
06/02/2018$ 18,23$16,41$20,05
07/02/2018$ 18,41$16,57$20,25
08/02/2018$ 18,59$16,73$20,45
09/02/2018$ 18,77$16,90$20,65
10/02/2018$ 18,96$17,06$20,85
11/02/2018$ 19,14$17,22$21,05
12/02/2018$ 19,32$17,39$21,25
13/02/2018$ 19,50$17,55$21,45
14/02/2018$ 19,68$17,71$21,65
15/02/2018$ 19,86$17,88$21,85
16/02/2018$ 20,05$18,04$22,05
17/02/2018$ 20,23$18,20$22,25
18/02/2018$ 20,41$18,37$22,45
19/02/2018$ 20,59$18,53$22,65
20/02/2018$ 20,77$18,69$22,85

 

If this graph is no possible at all in Power Bi, can you guide me to the link for further information regarding the forcasting feature?

Thanks a lot!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.