Forum Discussion

Stevenrizado's avatar
Stevenrizado
Frequent Visitor
8 years ago
Solved

Clustered & Line Column Chart - Line value does not align with actual value

Hi everyone,   So I've been learning my way through Power BI using trial & error, and I've created a Line & Clustered Column Chart in order to show the absence frequencies per month per business un...
Need Help
  • ValentinBIA's avatar
    ValentinBIA
    8 years ago

    Hi Stevenrizado,

     

    When you click on your Line & Clustered Column Chart. go to the Visualization pane, and then Format tab.

    On the format tab expand the Y-Axis part, and there you can set a Start and an End value for your Y-Axis Column, and if you scroll a bit down, you will see that you can set a Start an End value for your Y-Axis Line aswell.

    Try setting the same value for Start and End for both the Y-Axis Column and Y-Axis Line. You should get what you are looking for.

     

    Hope I understood correctly your issue, and that my post will solve your problem.

     

    Best,

     

    Valentin

ValentinBIA's avatar
ValentinBIA
Resolver I
8 years ago

Hi Stevenrizado,

 

When you click on your Line & Clustered Column Chart. go to the Visualization pane, and then Format tab.

On the format tab expand the Y-Axis part, and there you can set a Start and an End value for your Y-Axis Column, and if you scroll a bit down, you will see that you can set a Start an End value for your Y-Axis Line aswell.

Try setting the same value for Start and End for both the Y-Axis Column and Y-Axis Line. You should get what you are looking for.

 

Hope I understood correctly your issue, and that my post will solve your problem.

 

Best,

 

Valentin

Stevenrizado's avatar
Stevenrizado
Frequent Visitor
8 years ago

Fantastic Valentin!

 

Simple, yet so effective.

 

Take care,

Stefan