Forum Discussion
Need to optimize filters
I have a large dataset that contains roughly 7 million rows with about 16,000 distictive results. The dataset contains entries (rows) that do not provide value to the dashboard and need to be excluded. The problem I'm running into is that I have around 30 filters and counting which seems to be having an impact on the dashboard performance.
The filters are set to "Filters on all pages" in case that matters.
Is there a way I can exlude these items as the business indentifies them without having to create filters? Would DAX or Query builder do it? If so how?
Thank you in advance for the help.
Could you consider filtering them out using Power Query - specifically the filtering by values? This would be an option if you have access to the data source. This would be faster than the page-level filters as the irrelevant data is processed before it reaches the dashboard. Check out the official Docs here to get started: https://learn.microsoft.com/en-us/power-query/filter-values
2 Replies
vicky_Super User
Could you consider filtering them out using Power Query - specifically the filtering by values? This would be an option if you have access to the data source. This would be faster than the page-level filters as the irrelevant data is processed before it reaches the dashboard. Check out the official Docs here to get started: https://learn.microsoft.com/en-us/power-query/filter-values
Thank you this worked for me!
