Forum Discussion
"Too many values" calculation is incorrect when adding a legend.
Microsoft EmployeeHi neilp1,
There are too many values indeed though they are blanks. You can see how the legend works from the following picture.
We still can show the data of your visual.
What would you like to do exactly? Maybe there is better solution.
Best Regards!
Dale
I'm not sure I understand. Could you explain exactly how there are too many values? The number of rows is the same!
It sounds like PowerBI is being over protective here - the number of possible rows is higher, but the error is showing even though the number of actual rows is within the allowed limit.
- v-jiascu-msft
Hi neilp1,
Let's go on this example. There are only three rows at the start. But when the Color legend is added in, the rows turn to every Color multiply every year. That's why there are many many records.
Best Regards!
Dale
Hi Dale,
I understand that in your example, although in your example your source data has more rows than the 3. In my example, all the source rows are displayed in the first example, so there are no more possible rows.
It seems that power bi limits the data based on the possible values, not the actual number of rows in the source dataset.
if I chart x by a legend of y - Power BI will tell me there are 50 possible rows (10x5), whereas the source data only actually has 10?. Is that correct?
x,y
1,a
2,a
3,b
4,b
5,b
6,b
7,c
8,d
9,b
10,e
If so, can this behavour be changed so that it will chart the 10 rows because it never really has 50? My point it that the limit is being applied too agressively when it is assuming more rows than really exist in the data.
- v-jiascu-msft
Hi neilp1,
I'm afraid this is how legend works. But if you share the expected result you want, maybe we can find the proper solution.
Best Regards!
Dale