Number formatting in Highcharts

Hi All,

I am trying to create a bubble chart using highcharts and want to format the tooltip value to percentage format. How do I set this up ?

“tooltip”: {
“useHTML”: true,
“pointFormat”: “{point.name}{point.value:,.2f}”
}
What changes are needed in the format to achieve this?

Thanks,
Prantika

Hello @prantika_sinha !

Can you try adding a suffix? Something like below:

valueSuffix: ’ %',

“tooltip”: {
“useHTML”: true,
“pointFormat”: “{point.name} {point.value:,.2f},
“valueSuffix”: ’ %’
}

1 Like

That did not help. ‘%’ is throwing error, so tried with “%” as well.

1 Like

Hey @prantika_sinha !

What’s the error and what does the code for your tool tip look like?

Here is the code I used:

{
  "chart": {
    "type": "packedbubble"
  },
  "tooltip": {
    "useHTML": true,
    "pointFormat": "<b>{point.name}</b>{point.value:,.2f}",
    "valueSuffix": "%"
  },
  "plotOptions": {
    "packedbubble": {
      "minSize": "30%",
      "maxSize": "3000%",
      "zMin": 0,
      "zMax": 1000,
      "layoutAlgorithm": {
        "splitSeries": false,
        "gravitationalConstant": 0.05
      },
      "dataLabels": {
        "enabled": true,
        "format": "{point.name}",
        "filter": {
          "property": "y",
          "operator": ">",
          "value": 250
        },
        "style": {
          "color": "black",
          "textOutline": "none",
          "fontWeight": "normal"
        }
      }
    }
  },
  "series": [
    {
      "name": "Series1 ",
      "data": ["getColumnFromValue", 0]
    },
    {
       "name": "series 2 ",
      "data": ["getColumnFromValue", 1]
    },
    {
       "name": "series 3 ",
      "data": ["getColumnFromValue", 2]
    }
  ]
}

This is not throwing error, but the values in the tooltip is appearing in decimal which I want to be in percentage.

When I try adding suffix using single quotes, I believe the syntax is not correct throwing the error like :

@duncan Any suggestion to fix this?

Hello @prantika_sinha !

I’m sorry about the late reply! Were you able to find a solution or workaround? I’m basing this off of the documentation available from High charts. It’s possible that this needs to be a feature request for the QuickSight team.

No luck yet! Thanks for checking :slight_smile:

1 Like

@prantika_sinha no problem, I’ll go ahead and mark this as a feature request for the QuickSight team!