Search found 3 matches

by Eamonn
Tue Feb 12, 2019 10:06 pm
Forum: PowerPivot/DAX
Topic: Drilldown 1000 row limit in PowerPivot or PowerBI.com Analyse in Excel
Replies: 4
Views: 879

Re: Drilldown 1000 row limit in PowerPivot or PowerBI.com Analyse in Excel

no worries Phil, very much appreciate the input!
by Eamonn
Tue Feb 12, 2019 1:01 pm
Forum: PowerPivot/DAX
Topic: Drilldown 1000 row limit in PowerPivot or PowerBI.com Analyse in Excel
Replies: 4
Views: 879

Re: Drilldown 1000 row limit in PowerPivot or PowerBI.com Analyse in Excel

Thanks Phil already tried it however that part is greyed out and therefore you cannot change the olap number. Or at least I haven't been able to. You'll see at about a minute 20 seconds of the video I uploaded me trying to do the same however the area is all grayed out.
by Eamonn
Tue Feb 12, 2019 4:53 am
Forum: PowerPivot/DAX
Topic: Drilldown 1000 row limit in PowerPivot or PowerBI.com Analyse in Excel
Replies: 4
Views: 879

Drilldown 1000 row limit in PowerPivot or PowerBI.com Analyse in Excel

In a normal Excel pivot table when you double click on a cell you can see the build out of that number i.e. the underlying numbers/transactions making up the summary figure, which sometimes might be many thousand rows of data. However in PowerPivot or PowerBI.com Analyse in Excel the number of rows ...

Go to advanced search