Forum Discussion
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 split it out by location. All of the data appears to be in a "Blank" location.
At first I was worried that something happened to our measure, but when it's viewed using the Matrix visualization, the calculation seems to be working well.
Any ideas how to fix the stacked bar chart to make it display correctly again?
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!
4 Replies
BPelzel why there is a blank()? Try to filter on blank() and see if it work, I think that is screwing up everything. Something is not right in your data after your recent data refresh.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
parry2k I don't know why it's showing blanks. There are no blanks in the tables. When I try to filter on blank in the visualization nothing shows up since they all have a value in the location field.
There are only two fields used in this visualization: 1) the location field and 2) the measure that calculates average. I was worried about an issue with the calculation or data, too, but when I view it as a Matrix or click on the option to "Show as a table", the calculation by location is fine and calculates appropriately.
Is there something specific in or about the data tables I should look for? Thanks!
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!
