Convert amounts

[Anonymous]

Hi.

I would like to know if it is possible to configure the data amounts, as follows:

Thousands (Mil) to Kilo (K)
Millions (Mi) to Mega (M) 
Billions (Bi) to Giga (G)

Greetings !

[v-yuta-msft]

@Anonymous ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[Anonymous]

Hi.

Unfortunately not !  I expected it to be an option of Pbi ...

[v-yuta-msft]

@Anonymous ,

I'm afraid currently there's no such built-in feature in power bi. As a workaround, you can create a calculate column using DAX function like format(), if that can't meet your requirement, you can manually construct your data format using functions like concatenate(), contains(), right(), left() and other text functions based on your senario.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Perhaps via FORMAT command