Forum Discussion

poornadeepthi's avatar
poornadeepthi
Regular Visitor
2 years ago
Solved

Power BI Line and Stacked Column Chart

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])
 

 

 

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    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

2 Replies

  • 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's avatar
      Anonymous
      Not applicable

      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