Custom number format display issue

[hansei]

Any of these custom number formats are used to hide 1000s. The second one is a bit clearer with the K appearing inline.

#,##0,
#,##0,"K"
0,

They all work in Excel as you can see in screenshot. (Strictly speaking, the formats in columns C and E are incorrect, but work anyway.)

In the Power BI model view (which uses the example number 123456.78), you can see them also working.

However they don't work at all on the report. The numbers end up displaying like "7,654,321K" in all visuals.

Removing the text allows the number format to work again (but is completely misleading) ...

... until you set the visual to do some formatting for you. 

Oddly, if you set display format while the text is still present, it ends up a little closer to reality, but fixes the problem nowhere else

[_AAndrade · Accepted solution]

Hi,

Check this link: https://community.fabric.microsoft.com/t5/Desktop/Changing-Number-Format/td-p/3710518#M1208645

And try this formatting: "#,##,.00 K"

[hansei]

Not actually wanting decimal places, I modified to (either of these)

#,##,.\K
#,##0,.\K

 
It makes little sense to me why an unused dot would fix the issue, but it did.

PBI still seems confused as to what the actual number is though.

But, I can live with that and duplicate the measure without custom formatting when I want to let a visual handle it for me.