With a power pivot/data model 'flattened pivot' i see filter dropdowns that arent correct

[Guitarmageddon]

Hello all,
I have three different tables being queried into my data model. Basically just a bunch of purchase orders. for the entire year.

At the request of the teams that use them, the data needs to just be in one large flat table. Previously, this was being manually copied/pasted/appended by someone daily. I have since made a query that seems to work just fine, and refreshes when needed to bring in all the new daily files someone dumps into a directory.

I have used a "flattened pivot" to put the results onto a sheet. However, if I, for example, filter on ORDER MONTH, and select lets say, December, it gives me filter dropdowns on the other columns for all the old data. Like a filter on december shouldnt allow me to see in the raw data column dates from every other day this year.

i see that in a NON power pivot context, you can go into the pivot table options window, and mess with the "retain items" dropdown. but that is not an option for power pivot derived tables. Any thoughts?

 

[Matt Allington]

Pivot tables require a calculation (something in Value) to correctly filter the rows. Add a text column to values. This could create a count implicit measure and that should filter it.