Hi,
I have multiple connection-only queries in my data set. One query in particular which has 1,008 rows, is returning an incorrect revenue sum in my Power Pivot chart. When I double clicked on that incorrect value, it loaded a new sheet with only 921 rows.
There are no filters in the data set and I am using explicit measures. What else should I check so that the revenue will be correctly summed up from the full number of rows ? Thank you.
Hi Linda,
If you put that measure into a PivotTable with nothing else does it return the correct value? If not, then I would go back to Power Query and check that something isn't being filtered out there.
If it does, then I would add the row and column labels to the PivotTable one at a time and see at which point the value becomes incorrect. It's difficult to say much more without seeing the file.
Mynda
Hi Mynda,
I am getting this same issue with another file. When I drill down a cell from my Power Pivot Table, it returns only 1,000 rows instead of 3,000+ rows. Is this a Power Pivot limitation or is there a setting I should change? Thank you.
Linda
Hi Linda,
I'm not aware of it being a limitation. Do the 1000 rows add up to the value in the PivotTable? If yes, then there's no limitation, instead it'll be a filter you have applied to the PivotTable that's restricting the rows being returned, just like the previous issue.
Mynda
Hi Mynda,
It must be a setting on my file. A colleague of mine solved it by clicking on Data, Queries & Connections, Connections at the top of the Queries & Connections pane, right click on This Data Model then increase 'Maximum number of rows to be displayed' from the default of 1,000. Thank you
Hi Linda,
Irrespective of that setting, which is just the preview setting, the Pivot Chart should still reconcile. In other words, these are unrelated.
Mynda
