Forum Discussion
"Too many values" calculation is incorrect when adding a legend.
Microsoft EmployeeHi 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
All I'm trying to achive is to colour the bars differently, based on the ranges of the axis.
Using my time axis example, I'm plotting data by every minute of the day, but would like to change the colour of the bar based on the hour of the day. Using the legend feels like the best way to do this as it will both handle the colour and draw the key.