Area chart with intervals on X axis

[harshadrokade]

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%

[v-jayw-msft]

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

[lbendlin]

Can you please show an example of what you mean by "monthly interval dates" ?

[harshadrokade]

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