How to format a number to show "B" for Billon?

[sd_kevin]

Hi,

Is there a similar formating option in Power BI (like Excel) that allows users to format the number with alpha-numeric values and still have the system recognize it as a number? I tried using FORMAT() however, it converts into into a text. I need the measure to be used on a line chart and text just won't work. And my manager don't wants to see "B" for billions and not the default "bn".

Thank you!

Kevin

[sd_kevin]

Oh my gosh!!! I never knew you could type your own in that box!!! Thank you so much!!

[ppm1 · Accepted solution]

To do that, you can select your measure and enter a custom format string in the ribbon.

You also need to set the Display Units to None.

Pat