Show Geographical Map numbers in Million in Power BI

[Anonymous]

Hi,

I am new to Power BI.

I want to show all numbers from Map in Millions. Currently it is showing whole number. instead of that I want to show 206M. (Please see the attached map)

I am not able to find any 'Data label' option to format the numbers in Million.

Is there any way to format the number in Million?

Thanks!

Regards,

Poonam

[v-piga-msft]

Hi @Anonymous,

By my tests, it seems that there is no option for us to set the display units under format for Map visualization.

As a workaround, you could create a measure or calculated column like below.

Million_format =([Your Value] / 1000000) & "M"

Best Regards,

Cherry

[Anonymous]

Hi @v-piga-msft,

Thanks for the reply.

But in that case I am not able to sum all this numbers based on Region as I cant sum all the measures who has 'M' suffix (Text) as number.

Regards,

Poonam