Forum Discussion
Relative date periode
It's not a simple feature at all. This is one of the most complex requests because it contrary to the design idea of Power BI.
There is an option to use static text to make this dynamic (ironic, isn't it?) but it's not simple.
The basic idea is that your slicers remember their last value. You take advantage of that by creating a calculated column that always assigns a stati text to the latest data date, like "Latest Snapshot". Then you can select this "Latest Snapshot" in the slicer and the next time the user opens the report they see the selection based on the latest data.
There are a number of caveats:
- It is assumed that your dataset refreshes daily-ish
- All your other dates need to be converted to text too. So you need to spend additional effort to create a new calculated column (like day number) that you can then use to correctly sort your dates (which are now text)