cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nawaz
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?

157886461_146380307266216_3433774581306608383_n.jpg

 

 

 

 

 

 

 

Thanks in advance for your support.

Regards,

Ahsan 

2 REPLIES 2
negi007
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


AllisonKennedy
Super User III
Super User III

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



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. 


www.excelwithallison.com

Helpful resources

Announcements
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!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors