We have a stacked chart on a dashboard (one bar chart and one line chart combined). If one of the values is low, the bar chart is displaying zero above the bar even though the tooltip shows it does indeed have a value.
This is happening with both Custom Question and Native Query, but the below steps are a quick way to reproduce it with a Native Query.
Question 1:
select '2021-01-01' as x_axis_1, 'A' as x_axis_2, 1000 as y_axis from dual
union all
select '2021-01-02' as x_axis_1, 'A' as x_axis_2, 10 as y_axis from dual
union all
select '2021-01-03' as x_axis_1, 'A' as x_axis_2, 1000 as y_axis from dual
Question 2:
select '2021-01-01' as x_axis_1, 'A' as x_axis_2, 20000000 as y_axis from dual
union all
select '2021-01-02' as x_axis_1, 'A' as x_axis_2, 30000000 as y_axis from dual
union all
select '2021-01-03' as x_axis_1, 'A' as x_axis_2, 20000000 as y_axis from dual
Then stack the 2 questions on a dashboard. The values for Question 1 should be set to be Bar. The values for Question 2 should be set to line.
When viewing the stacked chart, the bar value that should display 10 is actually displaying 0 instead. If you hover over it, the tooltip shows 10 though. See screenshots below.
Snowflake
Metabase v0.39.3
Both Custom Question and Native Query have the same problem.
Chrome Version 91.0.4472.77 (Official Build) (64-bit) ... all browsers
Windows 10
Bug 14828 looked similar but it may not be the same.
on the first post