Forum Discussion
How to plot a multi year range in area chart
I have a daily dataset that goes back a number of years. The format is as follows:
| Date | Type | Volume |
| 1/1/2015 | A | 50 |
| 1/1/2015 | B | 12 |
| 1/1/2015 | C | 77 |
| 1/2/2015 | A | 100 |
| 1/2/2015 | B | 78 |
| 1/2/2015 | C | 62 |
| 1/3/2015 | A | 20 |
| 1/3/2015 | B | 61 |
| 1/3/2015 | C | 32 |
| 1/4/2015 | A | 35 |
| 1/4/2015 | B | 20 |
I would like to sum up the dailies, capture the minimum and maximum values for each day, then plot on an area chart with a line showing the average, as shown in the chart below. This is relatively simple in Excel and I'm wondering if it can be done in Power BI. Link to the spreadsheet is as follows:
https://drive.google.com/file/d/17adY-LTt9XdZOvNnxhSrWdpJkJv4xKDO/view?usp=drivesdk
I thank you in advance for any assistance!
2 Replies
Hi cynthial ,
Based on what I've tried, it's going to be a lot of trouble getting this kind of vision. And I can only by creating measures and using "MM DD" as the X axis to get the visual.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I see - that's a bit disappointing, but thank you Liang for your help with this!
