Value Labels in graphs showing in different format

Hello,

I created a value format to simplify large numbers, but i needed to use localization so i used HTML as well to be able to translate the string millions to milliard in french. Example: EN 21.16 B€, FR 21.16 Mds€

Nevertheless, when i display the values in a graphic,  it only shows the value format without the text. Example: 21.16

Here ir my lookml code:

named_value_format: eur_formatting {
  value_format: "[>=1000000000]\"\"#,##0.00,,,\" \";[>=1000000]\"\"#,##0.00,,\" \";[>=1000]\"\"#,##0.00,\" \";\"\"#,##0.00"
  strict_value_format: yes
}

  measure: commitment_m {
    label: "total_commitment"
    type: sum
    value_format_name: eur_formatting
    sql:${commitment} ;;
    html:
    {%if value >=1000000000 %}
    {{rendered_value}}{{_localization["B"]}}€
    {%elsif value >=1000000 %}
    {{rendered_value}}{{_localization["M"]}}€
    {%elsif value >=1000 %}
    {{rendered_value}}{{_localization["K"]}}€
    {% else %}
    {{rendered_value}}€
    {% endif %}
    ;;
  }

2 0 175
0 REPLIES 0
Top Labels in this Space
Top Solution Authors