Skip to content

Number format #% not being respected when also using Annotation series for Google Bar Chart #1221

@gisjason

Description

@gisjason

Description

I've only tested this on a small dataset, but it seems that when setting some data to annotation it breaks the #% number format on one of the series in the hover text. See Screenshots. This bug occurred with a Bar Chart for Google Charts, I have not tested it with other charts.

Step-by-step reproduction instructions

Here is a sample dataset that breaks the #% in the third series when (N) series are set to annotation. (See screenshots).

To reproduce: In 'Series Settings' set each (%) series to 'Special Role' = 'Default (data)' with 'Number format = '#%' and set each (N) series to 'Special Role' = 'Annotation' to reproduce the bug. Hover over the series in the chart and notice the third series is not showing the value as a %, but rather as a decimal.

Q1_2025,2025(%),2025(N),2017(%),2017(N),2010(%),2010(N)
string,number,string,number,string,number,string

  1. State grants authority…,0.49,(20),0.47,(18),0.61,(NA)
  2. State splits authority…,0.29,(12),0.26,(10),0.23,(NA)
  3. Overlap or shared authority...,0.22,(9),0.26,(10),0.16,(NA)

Here is a dataset that shows the bug does not show up when all (%) series are set to number format ='#%' and no series are set to annotation:

Q1_2025,2025(%),2017(%),2010(%)
string,number,number,number

  1. State grants authority...,0.49,0.47,0.61
  2. State splits authority...,0.29,0.26,0.23
  3. Overlap or shared authority...,0.22,0.26,0.16

Screenshots, screen recording, code snippet or Help Scout ticket

Image

Image

Environment info

No response

Is the issue you are reporting a regression

No

Metadata

Metadata

Assignees

Labels

bugThis label could be used to identify issues that are caused by a defect in the product.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions