Stacked Column Chart - Y axis scale

Power BI Data Model
1

Hello Fellow Power BI Users -

I have made a line and stacked column chart in Power BI. There are two Y axis. In one I plot the Capacity and in other actual production.
Both the Y axis should be in same scale to understand the graph.
I am not able to set both the axis in same scale. Can you please help.

I have attached the file along with this.

image
image.png1104×459 22.3 KB
CapacityVsActual.pbix (2.1 MB)

2

Hi Krishna,

Hope this is what you are looking for.

image
image.png1514×769 62.8 KB

3

Yes

But both the Y axis don’t have the same End value when left to ‘Auto’

image
image.png1126×465 34.1 KB

Do you have any idea - Why is this happening ?

I also want this graph to dynamically change the ‘End Valve’ when we select different plants in the slicer.

4

If you select ‘Auto’ as the End Value then it will dynamically select the nearest maximum thousands from the respective measures to plot the graph. In your case, Y axis in left has used P5 where nearest maximum thousand is 50000 and the right side has used Deliverable Cap where nearest max value is 80000. So ‘Auto’ is the only option that currently available(!!!Bearing mind, I am no expert) where the end value can be dynamically selected to plot the graph. In order to improve the contrast between two measures you could switch off the secondary Y axis from the graph so it will dynamically select max value from both measures.

image
image.png1459×822 57.7 KB

5

Thanks Thanura.

I tried and your suggestion works.

6

That’s great.

Yes you can also turn off the secondary axis if that would help also