Forum Discussion
Text Orientation With Histogram
Hello Team,
I'm new in this forum and I'm blocked with a report.
I want to use a Histogram and to modify orientation texte in 45 degrees for X axes, but I don't find this option, can you help me please? Why I can't see it?
See belows two capture when can you the type of histogram and second capture where you can see the "format your visual"
Thank you very much for your help.
(Sorry if ma English is'nt very wel)
Sonia_14 - thank you for the screenshots, but as I have mentioned there is no setting to make this text at a 45 degree angle.
What Power BI actually does
-
Power BI automatically rotates X-axis labels (e.g. 45° or vertically) based on the available space, chart size, label density, and axis type (categorical vs. continuous): https://stackoverflow.com/questions/63767222/how-to-rotate-labels-in-power-bi?
-
There's no user-accessible toggle or text box to specify a custom rotation angle in standard visuals such as bar, column, or line charts .
-
Similar BI forums responses reiterate that rotation isn’t configurable manually, and it’s “decided by the visual automatically": https://community.fabric.microsoft.com/t5/Desktop/Rotating-the-angle-of-x-axis/td-p/2482674
How to influence label orientation
Because there's no explicit rotation control, users manipulate chart dimensions and axis settings:
-
Resize the visual
-
Narrowing it often triggers automatic tilting to avoid overlap. Widening can restore horizontal labels: https://community.fabric.microsoft.com/t5/Desktop/X-axis-label-formatting/m-p/4246550
-
- Switch axis type to Categorical (versus Continuous)
-
This can affect label layout and spacing: https://stackoverflow.com/questions/63767222/how-to-rotate-labels-in-power-bi
-
- Adjust padding / category width
-
In the Format pane under Columns → Spacing, increase “Minimum category width” to nudge orientation:https://community.fabric.microsoft.com/t5/Desktop/How-to-keep-the-X-axis-label-in-vertical/m-p/910412
-
- Disable “Concatenate labels”
-
When using multiple fields on the axis, turning this off avoids long concatenations and improves clarity: https://community.fabric.microsoft.com/t5/Desktop/X-axis-label-formatting/m-p/4246550
-
- Use shorter labels or abbreviations
- Simplify label text to reduce clutter and rotation need .
Workarounds or alternatives
-
Custom visuals can allow you to specify rotation angles: https://community.fabric.microsoft.com/t5/Desktop/Rotating-the-angle-of-x-axis/td-p/2482674 .
-
R or Python visuals let you create plots with explicit
rotation=45 orax.tick_params(rotation=45), but that only applies to those visuals and requires embedding code. -
Submit an idea to Microsoft via the Power BI Ideas forum if you’d like official support for manual label rotation.
Bottom line
-
No manual “Rotate text” or “Label rotation” setting exists in Power BI’s standard visuals.
-
Label angles are automatically managed based on layout – you can influence but not control them.
-
For explicit control, opt for custom visuals, coding approaches, or file a feature request.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
-
6 Replies
Sonia_14 - You can't find it, because unfortunately it is not an option. Axis text orientation will be decided by the size of the chart, text and available space within the visual boundaries.
You can try and force this by setting the padding of the chart to custom, and making the space within the boundary of the visual smaller, but it will still change dynamically should the number of categories on the X-axis decrease with filtering.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
please share the dummy data pbix file and desired output sample within the file or by image to make ot easy to understand and work on.
Hey Sonia_14
Thanks mark_endicott and elitesmitpatel for your support so far, really appreciate you taking the time.
To help move this forward and make it easier to troubleshoot, could you please share a sample .pbix file with some dummy data and an example of the expected output, even a screenshot would be super helpful?That would make it much easier to understand the intended setup and logic. Let me know if you need help putting together the dummy data.
Thanks,
Akhil.Hello Anonymous elitesmitpatel mark_endicott
Thank you very much for your help.
Here are some screenshots showing my PBIX:
The Table which contains Satisfaction request (for summary):
With Power BI I have this screen:
Circle in Blue: Questions
Circle in grey: Response (Legend)
Circle in pink: Clients
I want to inclinate Clients text
Is it more clearly pour you or not please?
See Visualizations legends:
"ENTREPRISE" = Clients
Sonia_14 - thank you for the screenshots, but as I have mentioned there is no setting to make this text at a 45 degree angle.
What Power BI actually does
-
Power BI automatically rotates X-axis labels (e.g. 45° or vertically) based on the available space, chart size, label density, and axis type (categorical vs. continuous): https://stackoverflow.com/questions/63767222/how-to-rotate-labels-in-power-bi?
-
There's no user-accessible toggle or text box to specify a custom rotation angle in standard visuals such as bar, column, or line charts .
-
Similar BI forums responses reiterate that rotation isn’t configurable manually, and it’s “decided by the visual automatically": https://community.fabric.microsoft.com/t5/Desktop/Rotating-the-angle-of-x-axis/td-p/2482674
How to influence label orientation
Because there's no explicit rotation control, users manipulate chart dimensions and axis settings:
-
Resize the visual
-
Narrowing it often triggers automatic tilting to avoid overlap. Widening can restore horizontal labels: https://community.fabric.microsoft.com/t5/Desktop/X-axis-label-formatting/m-p/4246550
-
- Switch axis type to Categorical (versus Continuous)
-
This can affect label layout and spacing: https://stackoverflow.com/questions/63767222/how-to-rotate-labels-in-power-bi
-
- Adjust padding / category width
-
In the Format pane under Columns → Spacing, increase “Minimum category width” to nudge orientation:https://community.fabric.microsoft.com/t5/Desktop/How-to-keep-the-X-axis-label-in-vertical/m-p/910412
-
- Disable “Concatenate labels”
-
When using multiple fields on the axis, turning this off avoids long concatenations and improves clarity: https://community.fabric.microsoft.com/t5/Desktop/X-axis-label-formatting/m-p/4246550
-
- Use shorter labels or abbreviations
- Simplify label text to reduce clutter and rotation need .
Workarounds or alternatives
-
Custom visuals can allow you to specify rotation angles: https://community.fabric.microsoft.com/t5/Desktop/Rotating-the-angle-of-x-axis/td-p/2482674 .
-
R or Python visuals let you create plots with explicit
rotation=45 orax.tick_params(rotation=45), but that only applies to those visuals and requires embedding code. -
Submit an idea to Microsoft via the Power BI Ideas forum if you’d like official support for manual label rotation.
Bottom line
-
No manual “Rotate text” or “Label rotation” setting exists in Power BI’s standard visuals.
-
Label angles are automatically managed based on layout – you can influence but not control them.
-
For explicit control, opt for custom visuals, coding approaches, or file a feature request.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
-
