Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adding a legend removes/excludes values

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

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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:

     

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      This is how it's connected:

       

      Sorry for the blurring - I am using customer data.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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?