Converting 1,040K to 1,040M

[momar5]

Hi,

I have my data in the tables in millions but written as 1,040. Power Bi is reading it as thousands if I create a card for example. How do I make changes so it can read 1,040 as a million?

[amitchandak · Accepted solution]

@momar5 , one idea i got is, You have display text

format([measure], "#,###"& "M")

or multiple value by million in measure or new column