Forum Discussion

wonka1234's avatar
wonka1234
Icon for Helper III rankHelper 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") ...
Need Help
Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

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

  • wonka1234's avatar
    wonka1234
    Icon for Helper III rankHelper III
    1 year ago

    how do you change it to shared?

    • Deku's avatar
      Deku
      Icon for Super User rankSuper 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