Bar Chart with two values with major number difference

[Zee-Analyzes]

Hi People, 

Simple question here: a Bar chart with the measures one that is in Billions and another that is much lower - example in thousands - what can be done to make both columns show in a way that both are visible on the chart (elminating the scale differences) 

[katika555 · Accepted solution]

You can choose  Y axis->Scale Type End Sum of Lowest Values. 

[Zee-Analyzes]

Thanks for the tip - however i was hoping to find a solution that would keep the shape of the major column data proportional to their values instead of having them aligned on top with different values if you get what i mean