Forum Discussion

YunJ's avatar
YunJ
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Customize format to million

Hi,

I would like to customized format to million, but I want 0.7M for example rather than .7M as following. 

Thanks

 

Need Help

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Any idea about the format string for europen standard representation? example: 100.000,00

    • AliceW's avatar
      AliceW
      Icon for Power Participant rankPower Participant
      3 years ago

      It also works if you use it in a FORMAT function:

      format('Measures Table'[Amount],"#,##0,,.0M")
  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    5 years ago

    YunJ  You can do it by simply changing the Display units to milion and adding decimal places. Below is the screenshot to help you achieve it. I am not sure if you need custom format for this.

     

     

    • YunJ's avatar
      YunJ
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Hi negi007 Thanks for your reply. Sometimes I don't need "M", that's why I want to use custom format.