itil

ITIL Reporting

excel

ITIL 4

excel

Power BI

excel

Excel Formula | Macro | Script

Power BI: put a new text line and special characters in measure

To put a new line, it is quite easy, just put this:

&UNICHAR(10)&

And make sure that the “word wrap” option is on:

power bi

So for instance, I will create a measure by clicking on “home -> new measure” and I put a phrase. To see the result, I will create a “card” in the visualization and in the “fields”, I put the “measure”.

As you can see, it shows in 1 line because the “word wrap” option off.

power bi

Now if I turn on the option, I have 2 lines:

power bi

To put a special character:

  • I can press on my keyboard the windows key + dot or semicolon
    power bi
  • Or I can use an unicode: UNICHAR(unicode number)
    The same one as excel. For that, I will use this webpage Huge List of Unicode Symbols that references most of them. For instance to put an up arrow, I will look in the webpage the unicode number for the top arrow so my formula will be:
    power bi

Interesting Topics