Search code examples
powerbi

Why do fields still show in PowerBI when I have them filtered in the model?

My source data is full of data I don't need so I filtered them in my model in particular making sure none of the tags have the prefix CI: or AG:

enter image description here

Yet, when I create a table showing these values, I see rows that include data that should have been filtered away:

enter image description here

Why?

My process was to create a table "card" then click the values I wanted to include on the right:

enter image description here

I thought data I filtered in my model wouldn't be available to my report.

Solution

  • Filters you apply in Table view have no effect on your model. They are just a convenience for you to view data in that view. To filter these values out, you should do so in Power Query (Transform Data)