Power BI Desktop: Custom Formatting of Currency Fields

[Anonymous]

Hello All,

I need to format currency as $900.00 if value is less than $1000.00,

and $900K if value = $900,000.00

and $900M if value = $900,000,000.00

I cannot turn the final column/measure into TEXT field.

If I work with - Format-> Data lables(in my bar chart) -> Display Units -> Auto.. Then values less 1000.00 also come in the format - $0.9K for $900.00.

All other functionality (Million, Thousand etc) is as required in - Format-> Data lables(in my bar chart) -> Display Units -> Auto   

I just need to changes $0.9K for $900.00 for values less 1000.00???

Please give me some suggestions. Thanks,

[quentin_vigne]

Hi @Anonymous

When I choose Auto in Units, it's working for me, maybe because I've choose to display 2 numbers after the coma in the same place (Display units)

- quentin

[Anonymous]

Thanks Quentin,

Can you explain: I've choose to display 2 numbers after the coma in the same place (Display units)

I don't know where I can choose 2 numbers after the coma.

Display Units was working fine for me too, I wanted "K" and "M" etc. but if my Number Field is less than 1000, then I don't want formatting like "0.009K", rather I would like 9.00 instead of 0.009K for example.

[quentin_vigne]

@Anonymous

Sorry for the time of answer, here is the place where you can find it : 

Example of solution : 

Quentin