Forum Discussion
Add line break to column header in matrix visualisation
Anonymous,
You may use the following calculated column.
Column = SUBSTITUTE ( Table1[Column2], UNICHAR ( 32 ), UNICHAR ( 10 ) )
Hi,
No You cannot add a line break to the column Headers
Alternatively add a new record in the column used in Row Headers with value as Blank. Sorting it properly would make the Blank to appear below the Column Headers. This would give the look of a space after column header as any way you blank item in the Row Header will not have any data with it
Thanks Thejeswar, I was trying to do like this:
change:
December YTD
to this:
December
YTD
But I guess it is not possible. Sure wastes a lot of space!
Thanks for your help.
CM
We wanted to show
CY FCST as
CYFCST
Here's how we did it
- Open Microsoft Word
- Insert a symbol
- Find the "em space" unicode symbol (which is 32 decimal)
- Insert that into your Word doc
- Highlight that character and copy it to your clipboard
- Return to Power BI
- Typed in "CY", then CTRL+V to paste that unicode character, then "FCST"
- Power BI now respects the internal space enough to cause the words to wrap.
Worked for me. Make sure you have Text wrap set to On for Column headers.
Another option for typing these if you have keyboard with a number pad, you can hold down the Alt key and type 0160, which is a unicode "No-Break Space".
It's smaller than an Em Space, so I type one, copy it, and paste in as many as I need to shift the text to the next line. If you don't have a number pad on your keyboard, copy it from Word. You can find it quickly on the "Special Characters" tab.
If you are doing this right, the special spaces should appear in the column name after you rename it in the Visualizations pane like this:
If you just used normal spaces, they are visible while editing:
But after you hit enter, the whitespace is trimmed:
The "special" space characters don't get trimmed, so that's what makes this trick work.
I also put a "normal" space after the "special" space characters with the Alt+0160 and it works better. I don't think you need it with the Em Space, but you can try it if the line wrapping isn't working for you.
Anonymous,
You may use the following calculated column.
Column = SUBSTITUTE ( Table1[Column2], UNICHAR ( 32 ), UNICHAR ( 10 ) )
v-chuncz-msft wrote:
Anonymous,
You may use the following calculated column.
Column = SUBSTITUTE ( Table1[Column2], UNICHAR ( 32 ), UNICHAR ( 10 ) )
Why is this accepted as a solution?
