Line and Stacked Column - Why does Top line not work

[wonka1234]

hi all,

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. (Business values are either "A" or "B")

There are no filters.

X-Axis - Date

Y Axis - Count of Business

Y Axis Line - Count of Business 

Legend - Business 

expecting it to do this (red line) -

please help!

[v-achippa]

Hi @wonka1234,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Deku for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to 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.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @wonka1234,

We wanted to kindly follow up to 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.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @wonka1234,

As we haven’t heard back from you, we wanted to kindly follow up to 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.

Thanks and regards,

Anjan Kumar Chippa

[Deku]

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

[wonka1234]

how do you change it to shared?

[Deku]

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 different

If we set the min axis of both y axis to 0, and max to a measure

maxAxis = 
var measure1 =
    CALCULATE(
        MAXX( VALUES( 'Table'[Month] ), [a] )
        ,ALLSELECTED()
    )
var measure2 =
    CALCULATE(
        MAXX( VALUES( 'Table'[Month] ), [_y] )
        ,ALLSELECTED()
    )
RETURN
MAX( measure1, measure2 )

and now both are in sync