Treemap -- Change the look of Value (Thousand, Million, Billion) while hover over to a treemap

[Anonymous]

Hi Power BI Gurus,

I want to change the "Imports Value" while hovering over to a treemap, as seen in the attached image. Import value is in a million for example; $107,833,393.6 should look like $107.6M. Is there any possibility to do it in Power BI?

Thanks in advance for your support.

Regards,

Ahsan 

[negi007]

@Anonymous In this case you will have to create a new measure like below since you can customize data lable values but not tooltip value.

Measure = [Measure]/1000000 & "M"

use this in the tooltip. 

[AllisonKennedy]

@Anonymous  You can have a go at using the custom number formatting though it is limited: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

Otherwise you could create a measure that does the formatting for you, either using the FORMAT function, or simply:

Formatted Imports Value = DIVIDE( [Imports Value], 1000) & "K"