Visualizing a confidence level interval with an area plot

[Anonymous]

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.

Help is really appreciated!

🙂

[edwardcharles]

Been awile since this was posted but I made a youtube video on how to do this: Youtube Video 

[Greg_Deckler]

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

[Anonymous]

@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.

Date	Variable	Lower Bound	Upper 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!