Text Orientation With Histogram

[Sonia_14]

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)

[v-agajavelly]

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.

[Sonia_14]

Hello @v-agajavelly @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

[mark_endicott · Accepted solution]

@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:

1. 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 

2. 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 

3. 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/91041...

4.  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

5. 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 or ax.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!

[Sonia_14]

Hello @mark_endicott ,

Thank you very much for your response and you the détails.

I've tried reducing the visual and/or the columns but it adds a scrollbar each time.
It's a shame you can't adjust this sort of thing, and I can't find any visuals that allow you to do it.

In the meantime I've managed to present it differently, with the answers of 4 customers for the moment, but if I have 20 the boxes will be too wide.

I'm going to look at what you've sent me to see if I can find something to suit my needs.

Translated with DeepL.com (free version)

[elitesmitpatel]

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.

[mark_endicott]

@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!