Request for Best-Practice-Approach, filtering complete page / report based on edited Measure

[thomasreick]

Hello there,

I would like to comfort my customer with the following functionality:

• He should beable to edit a Measure called "PresentationDate" either hardcoded or with slicer.
• On that date a meeting takes place to show figures actual status vs 2 month before.
• The plan is to let him edit the measure (e.g. May, 11th 2025 = 11.05.2025 ) and all filters / slicers on the page(s)/ the report will addjust correctly based on that date.

Do you have or know any sources handling that kind of functionality / approach which you can share?

Thank you very much, have a nice easter weekend.

Thomas

[v-hashadapu]

Hi @thomasreick , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank you.

[lbendlin · Accepted solution]

Instead of using a measure consider using a disconnected calendar table with a date column that can feed your slicer, and can serve as a "filter on all pages".  (you wouldn't even need the slicer!)