Format Number "values" to Billions in the tooltip

[Anonymous]

Hello,

I am trying to format the Cost column to billions. I was unable to do so. I added a new measure with the below formula and I added it to the tooltip. Now, I cannot remove the Cost column from the tooltip. 

Flag - Cost in B = format(sum('Table'[Cost]),"$#,,,.#B")

What can I do to have the Cost Column formatted in Billions in the tooltip?

[MFelix]

Hi @Anonymous ,

If you need to apply this values to only this visualization you should opt by the custom tooltip.

If this is to be applied to the full table (so on you need to add a custom format to the column, this then will be used on all the visualizations.

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[Anonymous]

Thank you everyone for your contribution.

I have alot of visuals that are dependent on this column, so I will go with @MFelix suggestion.

@MFelix I have a question please, I have the numbers as "234,325,443,234.02", how do I write the custom format it to be in billions?

[MFelix]

Hi @Anonymous ,

On that visualization you will not see the example of the number if you go bvack to the Data view  you will see that is change to billions.

[Anonymous]

@MFelix Thank you so much for your help. 

I have one small question for you, do you think its possible to show the 0 on the left of the decimal place? So when its only 300 M, it'll show "0.3B" instead of ".3B"?

 

[MFelix]

Hi @Anonymous ,

You just need to play around with the # and 0 try the following format:

$0,,,.#B,

If you want them to all have the same number of decimals you can try

$0,,,.0B

[MFelix]

Hi  @Anonymous ,

Should be exactly like you wrote on the format that you used:

$#,,,.#B

This custom format uses the same syntax as in excel (except for the colouring).

[Anonymous]

@MFelix I think I am missing here something. When I added the format, it didn't show the number. Any idea why?

[AllisonKennedy]

Anything that is in 'values' will automatically show in tooltip. 

You could try using a report page tooltip instead: https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

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. 

https://sites.google.com/site/allisonkennedycv

[nandukrishnavs]

@Anonymous 

You can create a custom tooltip.

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂