Customize format to million

[YunJ]

Hi,

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

Thanks

[YunJ]

Thanks a lot @negi007 

[negi007]

@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]

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

[nandukrishnavs · Accepted solution]

@YunJ 

Try below format string

#,##0,,.0M

[Anonymous]

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

[AliceW]

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

format('Measures Table'[Amount],"#,##0,,.0M")