Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Line & Clustered Column chart

Hi, 

 

There are 5 group homes and I used a Line & Clustered Column chart to show Days of care each day with the line showing Capacity for all the  group homes.

When no houses has been checked the capacity shows 30 for all the houses , when I chose any house it shows 6 (Which is correct)

 

The capacity line shows on the top when no houses has been checked (Which is good)

My problem is when I check any house from the Group Home  List, the capacity line goes below the Days of care line, where it’s less than the Capacity

Please see the Images below..

Thanks,

spanda 

 

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    Thank you v-yulgu-msft !!

     

     

    It was like this above chart. I just played around with Y Axis & Changed the X Axis style from Categorical to Continuous & it works now. Thank you for your reply!!

     

     

    Thank you so much!!

    spanda

     

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Anonymous,

     

     

    From the screenshot, it looks like the capacity line is still placed on top of the column bars (Days of care). What is your desired output when you apply slicer filter?

     

    Regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you v-yulgu-msft !!

       

       

      It was like this above chart. I just played around with Y Axis & Changed the X Axis style from Categorical to Continuous & it works now. Thank you for your reply!!

       

       

      Thank you so much!!

      spanda

       

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you v-yulgu-msft !!

       

       

      It was like this above chart. I just played around with Y Axis & Changed the X Axis style from Categorical to Continuous & it works now. Thank you for your reply!!

       

       

      Thank you so much!!

      spanda