Forum Discussion
Report Level Filter - missing?
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.
Community ChampionAll 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.
Thank you.
Is there a way to limit the amount of data that is queried when I refresh?
Everytime I chnage a column header - it pulls the entire instance of salesforce. How can I prevent this?
Thank you!THANK YOU!!!! This works!!
- edhans
Excellent Anonymous - glad I was able to help out.