How to do Field formatting to millions in bubble chart ?

[Prash546]

The value table in this chart I want to appear in millions, I tried serching field formatting for the bubble visual however could not find the answer? 

[FrankAT · Accepted solution]

Hi,

1. Create a new measure which divides the value by 1000000.
2. Open Model view.
3. Enter a custom formatting for this measure (see figure 1).
4. The result looks like (see figure 2).

Figure 1

Figure 2

Regards FrankAT

[vanessafvg]

which bubble chart? and what is the format you wish to display 888M?

[Prash546]

I was referring to Scatter chart, and the format I am looking is millions with 2 decimal points.

[amitchandak]

As far as I remember there no tooltip formatting. You can do the column formatting in data tab, that should work. Or create a new measure with the format

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

[Prash546]

I am referring to scatter chart, and when we hover around I want to change the format, if I try formatting in the data itself it is getting rounded off and giving me incorrect value.