I have created a report using an sql date table, and existing semantic models from power BI.
The key date table is an sql table that I have successfully built relationships with the other tables.
I have made one-to-many relationships with:
Chatroom date > sql date
Forum date > sql date
SMS date > sql date
The first two tables are working fine with the sql date slicer.
However the SMS date will not use the slicer, but works fine when the sql date slicer is removed.
This table is an existing semantic model built from sharepoint. Same as the Forum table. I can't figure out why this is different? I have checked the date columns used and they are all in correct format.
@nmckeown1 can you check in the PQ what the type of this column is? Make sure it's type is a date, not a date/time.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
