Forum Discussion

Winniethewinner's avatar
Winniethewinner
Icon for Helper IV rankHelper IV
3 years ago

Power BI stacked area chart issue - Y axis alignment is different between desktop and Service

Hi everyone,    I'm experiencing a weird issue: I have a stacked area chart which min/max are set to auto, and in desktop it is exactly what I want it to be:    However, after I publish it ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Winniethewinner ,

 

According to PG's feedback, For combo charts (area+column) with multiple stacked series, the axis starts from zero. That is also the general expected behavior where area- That is also the general expected behavior where area- charts should start from zero. So the display on Power BI Service is by design, but the inconsistency is due to the fact that Desktop has not yet been synchronized with the update. Desktop will be updated with this issue in the September release.

 

PG also gives Mitigations:

  • If the users wish to have a narrower axis range, they can update minimum range to a desired value. 
  • Or they can change from area chart to line char, which still continues to set up a narrow range automatically, as this best practice is different for line charts vs area charts.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Winniethewinner's avatar
    Winniethewinner
    Icon for Helper IV rankHelper IV
    3 years ago

    Thanks Anonymous . That's an interesting change from Power BI. 

     

    In my scenario, the red part is always the biggest and I'd like to just track the revolution of other colors' %. Given the Y being always from 0, it's difficult to see other colors' trending. 

     

    Users can always manually change Y minimum to 0, so I don't really understand why PBI force it to be 0 and loosing the flexibility to display auto range based on the data.