Formatting from Tabular cube not respected

[MiKeZZa]

I have a (on premises) Tabular cube. This cube has a measure which I give a custom formatting. The strange thing is that when I have the value 123456789 custom formatting #,### works great; I get 123.456, as I expect.

But when I want to add the symbol K to this value (to make clear to the end-user that it is 123.456K, so it's 1000 times more) I use #,###"K" to get this behaviour. If I do that Visual Studio gives 123.456K, so that's good. Excel gives 123.456K, so that's good. But Power BI Desktop then changes tot 123.456.789K. This is not good.

Does somebody have an idea what I can do? Am I making a mistake (I make mistakes a lot, but in this case I'm thinking I'm doing the right thing...)? Is there a bug? Is there anything I must change/configure?

[Greg_Deckler]

@MiKeZZa - Where are you doing that formatting? Maybe #,###K

[MiKeZZa]

I did it in Visual Studio as formatstring in my SSAS Tabular Cube.

When I apply this format strings to a measure in PBI Desktop it works as planned.

[Anonymous]

Hi @MiKeZZa ,

You can refer the following documentation to format the number as #,##0,"K".

Show number in thousand (k) or in million (M) by using custom format

Best Regards

Rena

[Greg_Deckler]

@MiKeZZa Most likely will need to talk to some pure SSAS guys. There aren't a ton of them on these forums I do not believe.

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".