Trouble Removing Filter

[Sankey9913]

Hi Everyone,

Relatively new to BI so apologies in advanced.

I have a pretty simple model which got data from an excel workbook. All my visuals on my model appear to have a filter as pictured, which I don't remember adding. I can't remove it as it is greyed out. The date slicer allows me to pick dates outside of the filter, but no data appears as the filter is still applied. 

I don't know how this filter got there, or how to remove it. I am the only user as of right now.

Edit: Data outside the filters range exists withing the tables in the dataset. 

[amitchandak · Accepted solution]

@Sankey9913 , click on the filter. You should have the option to clear it.

what version of power bi you are on, make sure you are on latest version

[Sankey9913]

I cannot click on the filter... it is greyed out. If I right click, all the options are also greyed out.

On Version  2.88.1385.0

[amitchandak]

@Sankey9913 , very strange. Are you able to do any other changes? (is the file read only)

Open power query and check for any error and try to resolve if any.

[Sankey9913]

It was the only thing it wasn't allow me to do (that I had noticed at least). There were no errors of any kind, and all my data was loading correctly, just not viewable.

I actually just got it to work, I signed out and back in and it allowed me to remove them.