Forum Discussion
Post PartisanArea chart with intervals on X axis
I want to create below type of chart with given data where I want to show the X axis data with monthly interval dates on it. The Area chart availalbe on Power bi doesn;t allow us to decide the interval of dates on X axis. How can I acheive this?
Data-
| Date | Student score % |
| 24-Jun-21 | 4.01% |
| 25-Jun-21 | 4.02% |
| 28-Jun-21 | 4.05% |
| 29-Jun-21 | 4.04% |
| 30-Jun-21 | 4.05% |
| 01-Jul-21 | 4.04% |
| 02-Jul-21 | 4.06% |
| 05-Jul-21 | 4.09% |
| 06-Jul-21 | 4.18% |
| 07-Jul-21 | 4.17% |
| 08-Jul-21 | 4.13% |
| 09-Jul-21 | 4.17% |
| 12-Jul-21 | 4.22% |
| 13-Jul-21 | 4.10% |
| 14-Jul-21 | 4.11% |
| 15-Jul-21 | 4.12% |
| 16-Jul-21 | 4.13% |
| 19-Jul-21 | 4.13% |
| 20-Jul-21 | 4.12% |
| 22-Jul-21 | 4.14% |
| 23-Jul-21 | 4.16% |
| 26-Jul-21 | 4.17% |
| 27-Jul-21 | 4.18% |
| 28-Jul-21 | 4.19% |
| 29-Jul-21 | 4.20% |
| 30-Jul-21 | 4.20% |
| 02-Aug-21 | 4.20% |
| 03-Aug-21 | 4.20% |
| 04-Aug-21 | 4.20% |
| 05-Aug-21 | 4.21% |
| 06-Aug-21 | 4.23% |
| 09-Aug-21 | 4.22% |
| 10-Aug-21 | 4.23% |
| 11-Aug-21 | 4.24% |
| 12-Aug-21 | 4.23% |
| 13-Aug-21 | 4.23% |
| 17-Aug-21 | 4.23% |
| 18-Aug-21 | 4.23% |
| 20-Aug-21 | 4.23% |
| 23-Aug-21 | 4.24% |
| 24-Aug-21 | 4.25% |
| 25-Aug-21 | 4.24% |
| 26-Aug-21 | 4.25% |
| 27-Aug-21 | 4.26% |
| 30-Aug-21 | 4.23% |
| 31-Aug-21 | 4.22% |
| 01-Sep-21 | 4.21% |
| 02-Sep-21 | 4.18% |
| 03-Sep-21 | 4.16% |
| 06-Sep-21 | 4.16% |
| 07-Sep-21 | 4.19% |
| 08-Sep-21 | 4.19% |
| 09-Sep-21 | 4.18% |
| 13-Sep-21 | 4.19% |
| 14-Sep-21 | 4.19% |
| 15-Sep-21 | 4.17% |
| 16-Sep-21 | 4.16% |
| 17-Sep-21 | 4.18% |
| 20-Sep-21 | 4.14% |
| 21-Sep-21 | 4.12% |
| 22-Sep-21 | 4.13% |
| 23-Sep-21 | 4.14% |
| 24-Sep-21 | 4.18% |
| 27-Sep-21 | 4.21% |
| 28-Sep-21 | 4.22% |
| 29-Sep-21 | 4.21% |
| 30-Sep-21 | 4.22% |
| 01-Oct-21 | 4.24% |
| 04-Oct-21 | 4.25% |
| 05-Oct-21 | 4.26% |
| 06-Oct-21 | 4.27% |
| 07-Oct-21 | 4.26% |
| 08-Oct-21 | 4.32% |
| 11-Oct-21 | 4.34% |
| 12-Oct-21 | 4.33% |
| 13-Oct-21 | 4.31% |
| 14-Oct-21 | 4.33% |
| 18-Oct-21 | 4.39% |
| 20-Oct-21 | 4.37% |
| 21-Oct-21 | 4.34% |
| 22-Oct-21 | 4.36% |
| 25-Oct-21 | 4.35% |
| 26-Oct-21 | 4.36% |
| 27-Oct-21 | 4.34% |
3 Replies
- lbendlin
Super User
Can you please show an example of what you mean by "monthly interval dates" ?
harshadrokadelbendlin Hi Sir, you can refer the chart that I have posted. You can see that on the chart, I was able to show the dates on monthly intervals. You can see on X axis, after 28th Oct, we see next date as 25th Nov & then 23 Dec. So I could show dates on X axis with 28 days gap but the chart is showing all dates values on it. I want similar chart where chart plot area showing all dates values but X axis shows only monthly dates on it.
Hi harshadrokade ,
Change the x-axis type under Format pane to Continuous and turn on the Gridlines. However the interval is set automatically, you cannot customize it.
Best Regards,
Jay
