I have a requirement to apply a filter that filters on all pages in a report. The report, whenever it is refreshed should pick the new MAX/Earliest date from the Delivery column and use that to filter all pages. I am used to doing this if I was to apply it to a particular visual. There is the top N option to apply that works fine on the filter on this visual. I created a measure but measures don’t work with Filters on all Pages.
In this example, the current date for Delivery date is the 13th of June. I want that this date filters on all pages and to automatically pick up a new MAX/Earliest date when new data becomes available in the model, filtering all pages. Is there any way this is possible without having to manually change the date?
PreviousNcurrent.pbix (365.6 KB)