Power BI Line and Stacked Column Chart

[poornadeepthi]

Hello,

I am using Line and Stacked Column Chart to show the availability and target for FY hierarchy(FY and Month). I have two categories like A, B. When I drill down directly from FY to months the visual working fine. But when I add filter to visual as B like that and drill down to months. The visual is looking odd. 

Please help.

Measures I am using:

Bar = MIN([Available],[Target])

Marker Value = MAX([Available],[Target])

Met Bar =

var available = [Available]

var target = [Target]

return

  IF(available>=target, [Marker Value]-[Bar])

Target = CALCULATE(SUM('DigitalCASP'[Days]),FILTER('DigitalCASP','DigitalCASP'[Category]="CASP Target"))

UnMet Bar =

var available = [Available]

var target = [Target]

return

  IF(target>available, [Marker Value]-[Bar])

[poornadeepthi]

I think it is because showing two different ranges on the sides, if you see.

How to align these two ranges.

Appreciate your help.

[Anonymous · Accepted solution]

Hi @poornadeepthi ,

You can navigate to Format pane, change the range of Y-axis and second Y-axis separately to make them align just shown as the ones in below screenshot...

Best Regards