Forum Discussion
Helper IVDate column with date data type displays multiple values in filter
Hi TomSinAA,
Thanks for reaching out to the Microsoft fabric community forum.
To enable consistent date filtering across your data model, you should create a dedicated date dimension table and establish one-to-many relationships from this calendar table to the date fields in your other tables, with the calendar table on the 'one' side. This allows you to apply filters to the shared calendar table, which will then propagate through the model via these relationships.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
Hi TomSinAA,
Thanks for reaching out to the Microsoft fabric community forum.
To enable consistent date filtering across your data model, you should create a dedicated date dimension table and establish one-to-many relationships from this calendar table to the date fields in your other tables, with the calendar table on the 'one' side. This allows you to apply filters to the shared calendar table, which will then propagate through the model via these relationships.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards