Forum Discussion
Chart showing incorrect value
I have two stacked column chart : chart one displays net sales sum by year (x axis) and other chart shows net sales by year (x axis) and product (legend). The first chart shows correct total net sales for each year whereas the second chart shows wrong sum of sales. When I export the second chart data in excel there it shows the correct sum.
Any reason why its happening?
9 Replies
Just check if it showing all the products, smaller values might not be visible. Can you share a better example?
I tried on my system and it does not reduce the value(I taken at the item level to have quite a few values ). It could be because of some visual level filters. Or formula has some filter. Please share screenshot and formula
Hi Anonymous ,
Based on my test using power bi desktop version : 2.78.5740.861 64-bit (February 2020). I cannot reproduce your issue here. Did you set any filter to your visual? Also you can share your sample data and excepted result to me by removing Confidential Information. Please upload your files to One Drive and share the link here.
Thanks for sharing.
