Worskhosp: Vega-lite chart config number format

Ask the Community
1

Hi,

How to set or config number format to local format.
thx in advance

{
  "decimal": ",",
  "thousands": ".",
  "grouping": [3],
  "currency": ["", "\u00a0€"]
}

Can use encoding below as example

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "data": {
    "values": [
      {"category": "A", "value": 1234567.89},
      {"category": "B", "value": 9876543.21}
    ]
  },
  "mark": "bar",
  "encoding": {
    "x": {"field": "category", "type": "nominal"},
    "y": {
      "field": "value",
      "type": "quantitative",
      "axis": {
        "format": ",.2f"
      }
    },
    "text": {
      "field": "value",
      "type": "quantitative",
      "format": ",.2f"
    }
  }
}
2

In the Vega docs I found some details around locale configuration in the config object. In practice, it looks like this:

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "config": {
    "locale": {
      "number": {
        "decimal": ",",
        "thousands": ".",
        "grouping": [3],
        "currency": ["", "\u00a0€"]
      }
    }
  },
  "data": {
    "values": [
      {"category": "A", "value": 1234567.89},
      {"category": "B", "value": 9876543.21}
    ]
  },
  "mark": "bar",
  "encoding": {
    "x": {"field": "category", "type": "nominal"},
    "y": {
      "field": "value",
      "type": "quantitative",
      "axis": {
        "format": ",.2f"
      }
    },
    "text": {
      "field": "value",
      "type": "quantitative",
      "format": ",.2f"
    }
  }
}