Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Stacked Area chart

Hi there,   Can someone please advise on why the lesser amount is showing above and the higher amount showing under?  I am using a calendar table I created for this and showing the Month Year optio...
Need Help
  • vanessafvg's avatar
    vanessafvg
    4 years ago

    Are you using 1 or 2 axis?   if you are using 2, rather drag the other on onto the primary axis and maybe that will help because they might be every so slightly misaligned.

     

    can you screen shot what you have placed on our visual in this place?  

     

     

    If that doesnt work then you will probably need to show your data differently if the values are similar, area chart is not  always good for that.  Maybe a line chart with more distinct colours between the 2.   Maybe a bar chart comparing 2 bars?   

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
4 years ago

are you able to share the data?  you might need to play with the formatting, because the labels are very close together.  I also think you using an older version of power bi, what version do you have?  Have you tried a clustered column chart?   that can give interesting visuals with 2 measures sometimes.

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
4 years ago

I think I am sticking with the Line chart as you suggested, thank you Vanessa.