Forum Discussion
big space between x-axis interval
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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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/1447523Hi 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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous
