Help with historical data

Hi  Clement_lav ,

Here are the steps you can follow：

You might consider appending dimension tables to a table using Power Query.

Connecting fact table to Append1 table.

This allows you to use the [date] of the fact table as a slicer to dynamically filter visual.

From your description I see that you want to set the slicer as default, as far as I know the power bi built-in slicer is not supported at the moment, you can consider using a custom visual -- “Preselected Slicer”.

We can get the three point in the "Visualizations", and we click the "Get more visual":

Then we find the "Preselected Slicer" and add the visual to our Power Bi Desktop.

First , we need to create a table with one column , and the value is True and False, like this:

Second , we can create a measure to define which the date we need to default preselected. If we need to default preselect then we return True else return False.

Flag =
IF(
    MAX('fact table'[Date])= TODAY(),TRUE(),FALSE())

Then we can put the [Date] in the Fields , [Flag] in the Pre Selection , 'Dirty Table'[Dirty Status] in the Dirty Status, like below screenshot: 

We can then dynamically pre-select today by default in the slice visualization, and when we select another date, we can restore the default selection by simply clicking the Reset button in the upper right corner.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly