Forum Discussion

BPelzel's avatar
BPelzel
Frequent Visitor
6 years ago
Solved

Stacked Bar Chart Not Displaying Averages Correctly

In the past, we have used a stacked bar chart to show a calculated average by location.  This month when I updated our data the chart doesn't display correctly. It does not show the average or...
Need Help
  • BPelzel's avatar
    BPelzel
    6 years ago

    Thank you for your help! I was able to figure it out this morning.

     

    There were two tables in this file. There were five employees who were on one table, but not the other.

     

    I'm still not sure why the matrix worked, but the visualization didn't. However, when I removed the five mis-matched employees from the table they were not supposed to be on, the visualization worked, too. Thanks again!

Icey's avatar
Icey
Community Support
6 years ago

Hi BPelzel ,

 

Please share us a dummy .pbix file for test. Please remove sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.

 

 

Best Regards,

Icey

BPelzel's avatar
BPelzel
Frequent Visitor
6 years ago

Thank you for your help! I was able to figure it out this morning.

 

There were two tables in this file. There were five employees who were on one table, but not the other.

 

I'm still not sure why the matrix worked, but the visualization didn't. However, when I removed the five mis-matched employees from the table they were not supposed to be on, the visualization worked, too. Thanks again!