Bar Chart total incorrect after adding 1 column as legend

[Karnik_]

These are the totals over the years before adding Product type Category in legend

After adding Product type Category in legend the total are wrong.

I have checked the column and there are no empty values in the Product type column still the totals dont add up. What could be the issue?

[Anonymous]

Hi @Karnik_ ,

As far as I know, your issue should be caused by your data model or some filter.

Is the column in Legend from the same table as other columns in your visual? If not please check the relationship between these columns. If yes please check whether there is some filters on your legend.

Please share a sample file with me and show me a screenshot with the result you want.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.