FILTERS ON THIS PAGE

[thebat276]

Hello, 

I have a filter on my dashboard set to exclude the value "TEST." The data source is an Excel file on SharePoint that Power Automate deletes and replaces with an identical filename. Although the data refreshes, a new filter option for "TEST" appears, and I have to manually uncheck it. How can I set the filter to automatically exclude "TEST" without manual adjustments every time the file is updated?

[DataNinja777 · Accepted solution]

Hi @thebat276 ,

I am assuming that your data has a column field with "TEST" and other than TEST, and with this assumption, you can filter TEST out by using the filtering function in Power Query.  If anything is unclear, please feel free to ask for clarifications.  

Best regards,