Forum Discussion

AdamMetz23's avatar
AdamMetz23
Advocate I
1 year ago
Solved

X-axis label formatting

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

 

Need Help
Tips and Tricks
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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's avatar
    v-csrikanth
    1 year ago

    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

4 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    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's avatar
    v-csrikanth
    Community Support
    1 year ago

    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

  • jhowell1's avatar
    jhowell1
    New Member
    7 months ago

    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's avatar
    v-csrikanth
    Community Support
    6 months ago

    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