Forum Discussion

Sankey9913's avatar
Sankey9913
New Member
5 years ago
Solved

Trouble Removing Filter

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. 

  • 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

     

4 Replies

  • 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's avatar
      Sankey9913
      New Member

      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's avatar
        amitchandak
        Icon for Super User rankSuper User

        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.