Forum Discussion
Problem with Drill-down pivot table
Hi Virty
No, I gave up and created the same dashboard with pivottables and slicers from a regular Excel table instead. For my needs it wasn´t really necessary with a Powerpivot table I only wanted the option to create measures in an easier way.
It really looks a bug to me too, at least I haven´t found any good reason why this functionality would differ Power Pivot models/regular excel tables. Because one thing is clear, it does differ.
Best regards
Fredrik
Hello Fredrik,
thanks for your fast reply.
I am also sure, that this must be a bug.
It's a pity that I have to create my dashboard based on a regular worksheet now. It increases the file size by several times and also my measures don't work anymore, so I have to use some work-arounds based on normal pivot tables.
Best regards,
Virty
- I'm pretty sure this is not a bug but rather a design problem in your model. FIlters MUST be set on fields containing JUST the filter values. For example: Suppose your data contains a column with (possibly repeating) date values. You should never filter your pivots on that column (field). Instead, you should be adding a date table which contains all dates (NO DUPLICATES!) you have in your model, create a link between the date and the data table and then filter your model using the date field of the dates table.
Hello Jan Karel,
I have tried what you've said and it's still not working. I still get the wrong amount of results back when I drill down having multiple selections within one or more data slicers and in one data slicer only one selection. So it's not a design problem. Seems to be a real bug.
So to make it clear:
I set select one item in any/all data slicers --> No problem.
I select 2 or more items in any/all data slicers --> No problem.
I select 2 or more items in any data slicers, but in one data slicer I select only 1 item --> Wrong amount of data sets in the drill down!
Best regards,
Virty
- I would need your workbook to try and figure out what the problem is.
