formatting help

[Anonymous]

Hi 

So I have a value for financed amount and i've had to divide it by 1000 to round the number.

for example its 55million but im having to divide by 1000 =  55000 
However, when in power bi id like it to still be shown as million or no units and have 550 instead of the whole number.
Is there a way to do this?
here is an example 

I'd like this to day 165M or 165 in a card visual 

[v-henryk-mstf]

Hi @Anonymous ,

Whether the advice given by  @selimovd  @Samarth_18 has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[Anonymous]

Hi, It did not solve the issue but i think its not possible to do so over power bi without changing it at the data source our adding in a measure 

[selimovd]

Hey @Anonymous ,

sure, you can do that with the custom format:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[Samarth_18]

Hi @Anonymous ,

Did you get a chance to check the display unit option?

Thanks,

Samarth