Adding legend changes values

[Anonymous]

Hi,

I have built a graph that is summarizing error data per month. I want to add a legend to show breakdown by type of error, but when I add this to the legend it changes my values.

Here is my graph before adding a legend

Here is my graph after: It changes the values to be 100% 

I had a previous graph in excel that looked like this, which is what I'm trying to replicate (data isn't updated which is why the numbers differ)

Any help would be appreciated!

[Anonymous · Accepted solution]

In my ex[perience this happens when you either have the data type wrong or you haven't set up a relationship correctly (if you're drawing data from more than one table).  I'd check you've got your data types correct first.

[amitchandak · Accepted solution]

Check your relation of legend with fact.

[Anonymous · Accepted solution]

In my ex[perience this happens when you either have the data type wrong or you haven't set up a relationship correctly (if you're drawing data from more than one table).  I'd check you've got your data types correct first.