Combo Chart - how to make 0 values on both axes to align

Get Help
1

image

Hi, I am using Community edition. I created the above chart. As you can see the 0 on both axis do not match. If I want to make 0 of both Y axes to align, whats the way to do it?
Any help would be great.

2

Hi @Mohan_Bharatia
That’s currently not possible:
https://github.com/metabase/metabase/issues/3897 - upvote by clicking :+1: on the first post
You could perhaps do some messy hack, where you added another series on one date, which had down to -45 (or whatever the match would be). That’s not something I would recommend.
Alternatively, have both Y-axis on the left (not sure which format they’re in, so don’t know if it will work)

3

Hi is this still unavaliable? This makes charts absolutely missleading:
I am currently pushing to move from Power Bi to Metabase which I think is really great, but all our clients complained about this.
Do youhave a way around? Or even better maybe this issue has been addressed by now?
Thank you

metabase1
metabase1662×343 36.9 KB

4

I flamber, is it still the upvote to do? the issue seem more general… Or maybe it has been sorted out by now. it is a basic feature that has been on Excel for the last 20+ years and tehre is a good reason for it. Thank you

5

@nono_london

I don’t understand your complaint. There is clearly a set of tick marks across the chart at the ‘0%’ mark. The closest data dot is just a little below those ticks, so is more than 0%. Your red lines are outside the bounds of the chart.

Can you elaborate on what behavior you want?

6

Hi thanks for your anwser, first it is not a complaint, I am very thanksfull about the app in general.

My point was that most charts offer the possibility to have the left axis 0 and right axis to be aligned.
I have attached a copy of the same charts on Power BI and Metabase, in power Bi you need to tick the “Align zeros” options in the secondary y-axis format panel in order to achieve this. I am wondering if this can be done in metabase. Thank you for your help

pbi_ca
pbi_ca677×386 38 KB

meta_ca
meta_ca621×270 36.2 KB

7

Thanks, I understand what you’re looking for now.

“Align zeros” would be a good option and could be added without having to address the larger issue of having full control over both Y axes (which Metabase lacks at the moment).

1 Like
8

yeah and it is available on line charts, i think it has been overseen for that chart. hopefully will be part of the next versions..