Forum Discussion

rjjcd's avatar
rjjcd
Regular Visitor
1 year ago
Solved

X axis values - non-breaking spaces / force angled values

Is it possible to have PowerBI respect non-breaking spaces in the X axis values? I'm trying to force long(er) values with multiple words to be treated as a single line of text to in turn force the charts to use angled values.

 

Nothing I'm trying works.

 

Have tried:

- Replacing spaces with char(160) in the Oracle SQL query feeding the dashboard

- Replacing spaces with Character.FromNumber(160) using the Replace Values feature

- Replacing spaces with #(00A0), again with Replace Values

- Copying and pasting a non-breaking space from Word

- Messing with X Axis Value maximum height

 

All result in the non-breaking space being treated as a regular space.

 

Happy to entertain other methods of getting the X axis values to be angled. 

 

Here's an example of what I want to avoid:

If this was treated as a single line (which I've tested by just removing the spaces), it would become angled at a 45 degree angle, and be infinitely more pleasing (in my opinion!) to look at.

  • Hi rjjcd 

    Interesting problem - it seems that all the common whitespace characters end up allowing line breaks when used on a horizontal axis.

     

    This might require some creativity in finding a suitable alternative.

    Here are a few that work (hex codes).

    115f Hangul Choseong Filler
    1160 Hangul Jungseong Filler
    2800 Braille Pattern Blank
    3164 Hangul Filler
    ffa0 Half-width Hangul Filler

1 Reply

  • Hi rjjcd 

    Interesting problem - it seems that all the common whitespace characters end up allowing line breaks when used on a horizontal axis.

     

    This might require some creativity in finding a suitable alternative.

    Here are a few that work (hex codes).

    115f Hangul Choseong Filler
    1160 Hangul Jungseong Filler
    2800 Braille Pattern Blank
    3164 Hangul Filler
    ffa0 Half-width Hangul Filler