March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello,
I created a Power BI report that displays a line graph of data for a date range of the last 24 months. I show the month name and year at the bottom x-axis. I had to create a date table to get PBI to keep my months separated.
The only annoying thing is the dates on the X-axis display slanted. This makes it hard for the user to line up the data point on the graph with the month below. Is there any way to change this to vertical? I want the data point to line up directly under the month name. I did some research online and the only suggestions I've found is to drag out the edges of the graph. I can resize the graph and it makes no difference. I've tried every option under Format-X-axis and nothing changes it. Any suggestions?
Solved! Go to Solution.
Hi @queryguy48 ,
According to your description, the direction of the x-axis is actually automatically set according to the size of the left and right borders. If the left and right borders are nerdy enough, then the date on the x-axis will automatically be displayed in the vertical direction to fit the size, and if the borders are wide enough, it will be displayed in the horizontal direction.
Also, if you are interested you can try a new custom visual object feature that powerbi has come out with that might give you more help.
Using in Power BI | Charticulator
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @queryguy48 ,
According to your description, the direction of the x-axis is actually automatically set according to the size of the left and right borders. If the left and right borders are nerdy enough, then the date on the x-axis will automatically be displayed in the vertical direction to fit the size, and if the borders are wide enough, it will be displayed in the horizontal direction.
Also, if you are interested you can try a new custom visual object feature that powerbi has come out with that might give you more help.
Using in Power BI | Charticulator
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
One option would be to build it with the Charticulator Visual. You would have flexiblity for text angle, tick marks, vertical gridlines, etc.
(15) Austin Power BI User Group - Charticulator 101 - YouTube
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
147 | |
92 | |
70 | |
58 |