Forum Discussion
Helper IHow to do Field formatting to millions in bubble chart ?
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?
Hi,
- Create a new measure which divides the value by 1000000.
- Open Model view.
- Enter a custom formatting for this measure (see figure 1).
- The result looks like (see figure 2).
Figure 1
Figure 2
Regards FrankAT
5 Replies
- amitchandak
Super User
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
Prash546I 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.
- vanessafvg
Community Champion
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.
- FrankAT
Hi,
- Create a new measure which divides the value by 1000000.
- Open Model view.
- Enter a custom formatting for this measure (see figure 1).
- The result looks like (see figure 2).
Figure 1
Figure 2
Regards FrankAT
