Data Model updates

[jaustin]

I have about 100,000 row model running in Excel 2016 Pro Plus. Have established a data model with two tables and recently created a Pivot Table from the data model. I needed to filter one of the columns and went back into the Manage PP screen. I was able to successfully filter the column in Data View. I then went back to the Pivot table and updated and expected the Pivot Table to be updated to the new filtered source, but it wasn't. Is this the wrong approach? I've considered trying to learn DAX for this type of function but haven't found a good source to get started (probably my fault, but the two I tried didn't do the job).

Thanks in advance,

jaustin

 

[gazpage]

You probably just need to right click on the pivot table and select refresh.

To be honest you shouldn't really be filtering the data model like that, as if you then wanted to create another pivot table that wasn't filtered you wouldn't be able to. Rather if you are filtering the row of column values right click on them in the pivot table, or if you are filtering by a different item then put it in the filters part of the pane on the right.

 

[jaustin]

gazpage,

Thanks for the response. Yes, I agree and have removed the filter from the PV data model page. I've decided on another approach that will take additional time, but is better for the long run. I have a fairly large number of slicers and pivot tables and have to keep them organized in order not to have "hidden" filtering when I don't want it. I'm still looking for a good DAX book. There is a new one coming out that looks pretty good but don't want to pay $50 for version 1 when version 2 is "supposedly" around the corner.

Thanks again,

jaustin