Forum Discussion

wonka1234's avatar
wonka1234
Helper III
1 year ago

Line and Stacked Column - Why does Top line not work

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!

Need Help

6 Replies

  • Deku's avatar
    Deku
    Super User
    1 year ago

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

      • Deku's avatar
        Deku
        Super User
        1 year ago

        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

         

         

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    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's avatar
      v-achippa
      Community Support
      1 year ago

      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's avatar
        v-achippa
        Community Support
        1 year ago

        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