X-axis label formatting

[AdamMetz23]

Hi Dear Community,

Have you ever met a similar situation before when you had a Stacked Column chart visualization and on the X-axis you had two fields (columns), in my example region and country.

Is there a way in formatting to make sure that both field characters are appearing in full and dynamically? Currently the region in my case is dotted out, e.g. EAPR..

Thank you for sharing your experience in advance.

Have a great day,

Adam

[rajendraongole1 · Accepted solution]

Hi @AdamMetz23 - when you are using stacked visuals where the width per category is constrained. While rotating or resizing may help, there are cases where switching to a different visual or concatenating fields is the most effective option and it is one of the limitation.

before moving to another visual, check this padding option if it helps on x-axis label.

If the X-axis values are too long and truncating is inevitable, switching to a Table or Matrix visual might give you more control over how data is displayed.Alternatively, consider using a Line and Clustered Column Chart, which often handles labels better by adding more space between them.

[v-csrikanth]

Hi @jhowell1 

Thank you for the feedback. You are correct that Power BI does not currently provide a user-defined fixed rotation option for X-axis labels in standard visuals, especially when using multiple fields on the axis. This is a known product limitation.

The suggested steps (resizing the visual, reducing font size, concatenated fields, etc.) are workarounds. They can help improve readability in some scenarios, but they do not guarantee full label visibility or consistent rotation behavior.

At present:

• X-axis label rotation is automatically controlled by Power BI

• Users cannot explicitly force vertical or angled labels

• The only way to trigger vertical labels is by reducing horizontal space, which is not ideal

Your point is valid that this limitation affects usability, and there is no clean workaround that fully resolves it today.

The recommended next step would be to raise this as an official feature request through Microsoft Ideas Fabric Ideas - Microsoft Fabric Community, as fixed label rotation would significantly improve axis readability for multi-field categorical visuals.


Thanks 
Cheri Srikanth

[jhowell1]

I don't know why this was marked as solved. It is absolutely not solved. The visual needs to have the option of a user-defined fixed rotation of the x-axis value. This needs to be the case, and isn't, in several standard visuals. The only way to force a visual to display x-axis values vertically is to smush the entire visual (horizontally) until pbi has no choice but to orient the x-axis values vertically... a bad feature with no good workarounds

[v-csrikanth · Accepted solution]

Hi @AdamMetz23 

Thanks for using the Microsoft Fabric Community.

Whenever a stacked column chart with two fields on the X-axis (e.g., Region and Country), the text can sometimes be truncated.This is because Power BI dynamically adjusts the space for labels based on the available size and axis formatting.

To avoid truncation and display both fields follow the below steps:

Step1) Increase the Chart Width:
Resize the chart to make it wider. This gives more room for the labels to be displayed fully.

Step2) Use a Concatenated Field:
Instead of using two separate fields on the X-axis (Region and Country),
you can create a concatenated column in Power Query or using a DAX calculated column, which combines both fields.

        FullLabel = [Region] & " - " & [Country]

The above DAX will ensure both fields are displayed in full without truncation.

Step3) Turn Off Concatenate Labels:
In the chart’s Format Pane:
Go to Format > X-axis > Concatenate labels and turn this off.
This will separate the two fields (Region and Country) on the axis, which can improve readability.

Step4) Adjust Text Size:
In the X-axis formatting options, try reducing the font size. This will allow more text to fit within the available space.

Step5) Rotate Labels:
You can rotate the X-axis labels by adjusting the Text Rotation under the X-axis format settings.
A slight rotation (e.g., 45 degrees) may help fit longer text labels without truncation.

Step6) Enable Word Wrap for Axis Labels:
Power BI doesn’t directly support word wrap for X-axis labels.
You can try one or a combination of these techniques to see what works best for your visualization.

If the above information helps you, please give us a Kudos and accept reply as a solution.

Thanks,
Cheri Srikanth

[rajendraongole1 · Accepted solution]

Hi @AdamMetz23 - when you are using stacked visuals where the width per category is constrained. While rotating or resizing may help, there are cases where switching to a different visual or concatenating fields is the most effective option and it is one of the limitation.

before moving to another visual, check this padding option if it helps on x-axis label.

If the X-axis values are too long and truncating is inevitable, switching to a Table or Matrix visual might give you more control over how data is displayed.Alternatively, consider using a Line and Clustered Column Chart, which often handles labels better by adding more space between them.