big space between x-axis interval

[dogburalHK82]

Hi, 

This is original graph with calendar year. 

Not sure why when I change x-axis with Financial year, the gap between year becomes bigger. 

anyone can help.

[v-rzhou-msft · Accepted solution]

Hi @dogburalHK82 ,

Here I can reproduce your issue on myside. When I change the calendar year to the fiscal year, it reduces the number of years on the x-axis and then the distance between the only remaining years will be too large.

Here I suggest you to refer to following step to change the X-axis.

Format your visual> Visual - X-axis >Type - change it from "Continuous" to "Categorical".

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dogburalHK82]

Thank you @v-rzhou-msft 

[Ritaf1983]

Hi @dogburalHK82 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523