Forum Discussion
Adding Date slicer picker for a table
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.
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,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- danextian
Super User
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.
Hello Thank you for response here is the file https://easyupload.io/y50ix3
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,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
