Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
🙂
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
@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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
2 | |
2 | |
2 |