cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexeyRusinov
Helper II
Helper II

Stacked column chart: horizontal label text with a scrollbar

Hello everyone,

 

I am creating a stacked barchart which is quite wide in horizontal (showing months in two years), and I am fine with having a scrollbar inside. But the labels on x-axis are displayed vertically, and I don't know how can I display them horizontally, as usual. When the chart doesn't have enough space, it starts to display labels first diagonally, and then vertically, without asking.

 

Is there a way to solve it?

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

Hi @AlexeyRusinov,

 

Based on my test in a stacked column chart, if I put the date field in X-axis, the and change X-axis type as categorical, the X-axis labels will display vertically and generate a scroll bar automatically. Actually, there is no OOTB feature for us to format X-axis labels's orientation. You can vote on this similar idea item: Change X and Y axis labels manually, similar to Excel.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

Hi @AlexeyRusinov,

 

Based on my test in a stacked column chart, if I put the date field in X-axis, the and change X-axis type as categorical, the X-axis labels will display vertically and generate a scroll bar automatically. Actually, there is no OOTB feature for us to format X-axis labels's orientation. You can vote on this similar idea item: Change X and Y axis labels manually, similar to Excel.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

I realize this was posted almost five years ago, but there has still been no addition to change the x axis label text direction.  This is a feature in Excel, I'm not saying every feature in Excel should be in Power BI... but they're both MS products so how is this still not a thing?  They made changes to the x axis labels according to that voting link you posted... but somehow the text direction wasn't considered? It's either vertical or horizontal, no other choice, no 45 degree option, nothing.

Habib
Responsive Resident
Responsive Resident

As of current release, its auto handled by Power BI desktop and you can't specify any option for this.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!