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