Custom number format display issue

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