Forum Discussion

charleshale's avatar
charleshale
Icon for Continued Contributor rankContinued Contributor
7 years ago
Solved

Legend not working correctly in stacked column chart

The attached PBIX is a simple Revenue By Customer (anonymized).  The data looks like this.  I also have a date table.     When I do a stacked revenue chart without a Legend, the numbers sum ...
Need Help
  • Sergiy's avatar
    Sergiy
    7 years ago

    It seems that Power BI simply can not include/calculate all the customers's data.

    If you filter data showing the results for a few customers only then the trend will be OK.

     

Sergiy's avatar
Sergiy
Icon for Resolver II rankResolver II
7 years ago

Hi charleshale 

 

The link to the file you provided is not valid.

 

I'll try to make a guess of what is happening. I think you have either Customer or Date column sorted by another column. If I am right make it sorted by itself and check the result.

 

Is my guess correct?

    • Sergiy's avatar
      Sergiy
      Icon for Resolver II rankResolver II
      7 years ago

      It seems that Power BI simply can not include/calculate all the customers's data.

      If you filter data showing the results for a few customers only then the trend will be OK.

       

      • charleshale's avatar
        charleshale
        Icon for Continued Contributor rankContinued Contributor
        7 years ago

        I agree - seems like a bug, right?   I'd expect the stacked chart to be able to handle N customers up to the memory limits, like excel!