Forum Discussion
Report Level Filter - missing?
Hello!
Where can I find the filter for REPORT LEVEL?
Everytime I refresh, my model queries the data for 5 years of Salesforce and it's driving me crazy.
The filter pane only shows THIS PAGE and ALL PAGES.
Thank you!
All Pages is Report Level. THere are three filters:
- Report Level - all pages
- Page Level - this page
- Visual level - this visual (only when you have a visual selected)
EDIT: I see you are talking about refreshes.
All DAX Filters only filter the existing data. You have to go into Power Query and filter the data as it comes in to exclude records. You need to go into Power Query and:
- select the column you want to filter and hit the dropdown
- Select Date Filters (or number filters if the date is in the YYYYMMDD format)
- Select how far back you want to go.
4 Replies
All Pages is Report Level. THere are three filters:
- Report Level - all pages
- Page Level - this page
- Visual level - this visual (only when you have a visual selected)
EDIT: I see you are talking about refreshes.
All DAX Filters only filter the existing data. You have to go into Power Query and filter the data as it comes in to exclude records. You need to go into Power Query and:
- select the column you want to filter and hit the dropdown
- Select Date Filters (or number filters if the date is in the YYYYMMDD format)
- Select how far back you want to go.
Excellent Anonymous - glad I was able to help out.