Adding Date slicer picker for a table

[Anonymous]

Hello , I would like to add a slicer where a user can pick a date,example 31/12/2023. The table is done but not sure how to implement correct date slicer picker,  the values are to the current date 05/12/2024, they are correct. Any help would be appretiated. I have "CompletedDate" as a historical date.

Leading Closed =

CALCULATE(

    COUNTA('CecLeadingCase H'[CecCaseId]),

    'CecCaseDetail H'[Case] IN { "Closed" }

)

[Anonymous · Accepted solution]

Thanks for the reply from danextian.

Hi @Anonymous ,

After opening the file you provided I didn't find any date related fields in the table, so here I have created simple example data:

Then create a new table:

The relationship is as follows:

Result:

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[danextian]

hi @Anonymous 

If there is an existing relationship between a dates table and your fact table, selecting values from a date slicer should filter your matrix as well. So what else do you mean? Please provide more context, a workable sample data (not an image) and your expected result from that.

[Anonymous]

Hello Thank you for response here is the file https://easyupload.io/y50ix3