Question

Column Chart Convert String type number into integer on x-axis

1

Hi all, I am using Mendix Column Chart (see below) to show ActionID (x axis) and its quantity (y axis) but the x axis “converts” the ActionId which is of string data type to what looks like integer (e.g. ActionId “801861” to 802k) . I am using a non-persistable table created via microflow as the data source for the column chart. Any idea what might have caused this issue and advice to fix it . Any Suggestion would be helpful.?

asked 2021-08-27

Bhanu Chauhan

3 answers

Anahit Pahlevanyan · Answer 1 · 2022-03-03

Hi any solution on this?

Affan Dawood · Answer 2 · 2022-03-03

You can try this, it will remove the k abbrevation for thousand

"xaxis": {
"tickformat": "000"
},

Anahit Pahlevanyan · Answer 3 · 2022-03-03

I found the solution

it is to put

{
"yaxis": {
"autotypenumbers": "strict"
}
}