Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!

🙂

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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!