Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

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

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.



Super User II
Super User II

@Nawaz 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. 

Did I answer your question? Mark my post as a solution!
Appreciate your Kudos

Proud to be a Super User!

Follow me here

Super User III
Super User III

@Nawaz  You can have a go at using the custom number formatting though it is limited:


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"

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos. ?

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors