cancel
Showing results for
Did you mean:
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.

Help is really appreciated!

🙂

2 REPLIES 2
Highlighted
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...

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

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

 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!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

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

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Get Ready for Power BI Dev Camp

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

Top Solution Authors
Top Kudoed Authors