Adding a legend removes/excludes values

[Xilitor]

Hi!

I have created a stacked bar-chart and when adding a Date-variable on the Axis and a measure on the Values it gives the correct output. Once I add a legend the output gives the wrong values. I have no filter enabled other than Year = 2019 and Month = July-December.

The chart without adding a legend (correct values):

The chart with a legend:

So, the only differences between the two charts above are the legend added.

I hope someone can help!

Thanks! 🙂

// BR

[amitchandak]

@Xilitor , I doubt join of legend with table or formula using some calculation on the legend

[Xilitor]

This is how it's connected:

Sorry for the blurring - I am using customer data.

[Xilitor · Accepted solution]

I found the solution:

For some reason the stacked bar chart can maximum display 58 different types of the legend. This means, that when I look at legends more than 58 types it chooses itself which to display.

Therefore, I added a filter to display only the top 58 filters by the measure used.

[Xilitor]

I just using all 3 variables from the same table and I still experience the same problem. So it cannot be regarding the relationships. And I have done no calculations for any of variables for this chart. Could it be because of a back-end problem then?

[Xilitor]

The legend detects the right number in a table but not in the chart.

E.g. selecting the legend in a table with the highest value doesn't highlight in the bar: