Forum Discussion
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
- OwenAuger
Super User
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