Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 doubt join of legend with table or formula using some calculation on the legend
This is how it's connected:
Sorry for the blurring - I am using customer data.
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.
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?
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:
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |