Share via

Power Pivot does not filter correctly

niftycat555 1 Reputation point
2022-08-03T03:23:25.81+00:00

I built a relational data model using power pivot. In the most simplistic view, I have a base data and a dimension table (many to one relationship). In the power pivot, I brought in a filter for the lookup value, "channel group" in the dimension table and under "Row" I brought in the "end user" field from the base data. My hope is to filter the "end user" field by the "channel group" but the power pivot seems to be giving me all "end users".

How can I fix this?

Thank you!

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
Community Center | Not monitored

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.