Line & Clustered Column chart

[Anonymous]

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 

[v-yulgu-msft]

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]

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 · Accepted solution]

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