Change Data Label from Millions to Trillions

[Terp]

BRAND new to PowerBi, but I have a table (thousands, actually) of data that are expressed in millions of U.S. dollars.

When constructing my first (yaaaah!) visual, the labels on my 'stacked bar chart' are showing, say, 1.9M (based on the underlying data, of course), but should read "$1.9T"

In Excel, I would merely format data label...number...custom format...and do something like $0.0,,"T" to change the "M" to a "T" and add a dollar sign.

Sure, I could reformat (thousands) of tables to express in actual numbers and add dollar signs and the like, but surely, I thought, there would be a way to change in PowerBI....but seems the Internet is riddled with similar asks with no solution other than creating new variables (like column 1 *1000) to accomodate any label formatting needs?!?

I hope this makes sense (my question, not the apparent lack of custom labels). 🙂

[Terp]

Being new, 'modeling' would have been the last place I looked, but I got this working...more or less.  🙂

Thanks again.

[amitchandak]

@Terp , In the visual properties, You have an option for Display Unit under Y-axis. There you can change.

2nd option is - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

[Terp · Accepted solution]

Thank you, sir!

I'll persue option#2 now, as I tried changing the display units, but that doesn't work...numbers are expressed in millions, so changing the 'display units' to, say, trillions shows 0.0T for everything, of course. 🙂

However, that 'Use custom format strings' is exactly what I was looking for...will give it a go now.

Again, many thanks, sir!