Line and Stacked Column - Why does Top line not work

Question

hi all,&nbsp;I am trying to make my line go to the top of each stack?I've checked the data and there definately is values for october in the business column.&nbsp;(Business values are either "A" or "B")There are no filters.&nbsp;X-Axis - DateY Axis - Count of BusinessY Axis Line -&nbsp;Count of Business&nbsp;Legend - Business&nbsp;&nbsp;&nbsp;&nbsp;expecting it to do this (red line) -&nbsp;&nbsp;&nbsp;please help!

deku · Answer

must be another visual I am think of. You can use a measure to set the min/max axis to the same. In this example you can see two axis are very differentIf we set the min axis of both y axis to 0, and max to a measuremaxAxis = 
var measure1 =
    CALCULATE(
        MAXX( VALUES( 'Table'[Month] ), [a] )
        ,ALLSELECTED()
    )
var measure2 =
    CALCULATE(
        MAXX( VALUES( 'Table'[Month] ), [_y] )
        ,ALLSELECTED()
    )
RETURN
MAX( measure1, measure2 )&nbsp;and now both are in sync&nbsp;&nbsp;

deku · Answer

try setting the y axis to shared. Looks like they are on different y axis

wonka1234 · Answer

how do you change it to shared?

v-achippa · Answer

Hi&nbsp;wonka1234,
&nbsp;
Thank you for reaching out to Microsoft Fabric Community.
&nbsp;
Thank you&nbsp;Deku&nbsp;for the prompt response.
&nbsp;
As we haven’t heard back from you, we wanted to kindly follow up to&nbsp;check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
&nbsp;
Thanks and regards,
Anjan Kumar Chippa

v-achippa · Answer

Hi&nbsp;@wonka1234,
&nbsp;
We wanted to kindly follow up to&nbsp;check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
&nbsp;
Thanks and regards,
Anjan Kumar Chippa

Forum Discussion

Related content

Stacked bar with line

Stacking Data Columns

Stacked Column Chart Data Labels

Need a stacked clustered column chart

Connecting lines Stacked Column Chart