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
Super UserHello TomSinAA ,
Why don't you make relationship to your DimDate instead of joining? İf you'd like to "Table view" in your PBI --> Click "New Table" --> paste your create_date script --> make relationship dimdate and facttable by date column (one to many). In you filter side you'll see only unique date's. That is best practice.
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |
TomSinAAI did create the relatationship. However it did not work until I created the delivery date column in the data table using the Date function rather than setting the data type to Date only.