Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Convert amounts

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 !

Need Help

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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.

     

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi.

       

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