Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Add line break to column header in matrix visualisation

Hello All,   Please does anyone know whether it's possible yet to add a line break in a column header in the matrix visualisation?   Thanks,   MR
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may use the following calculated column.

    Column =
SUBSTITUTE ( Table1[Column2], UNICHAR ( 32 ), UNICHAR ( 10 ) )
brentlightsey's avatar
brentlightsey
Icon for Advocate III rankAdvocate III
4 years ago

We wanted to show 
CY FCST as 
CY

FCST

 

Here's how we did it

  1. Open Microsoft Word
  2. Insert a symbol
  3. Find the "em space" unicode symbol (which is 32 decimal)
  4. Insert that into your Word doc
  5. Highlight that character and copy it to your clipboard
  6. Return to Power BI
  7. Typed in "CY", then CTRL+V to paste that unicode character, then "FCST"
  8. Power BI now respects the internal space enough to cause the words to wrap.
jimbob2285's avatar
jimbob2285
Icon for Advocate IV rankAdvocate IV
3 years ago

This doesn't work... At all!