Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, I'm pretty new to PowerBI so I could be missing something obvious but I have a Calendar table (named DimDate) and a Work Orders table that is has a 1 directional One to Many relationship (I've checked that both fields have the same date formatting and they do unless I'm missing something). For some reason, the measures relating to the Work Orders (such as the type of work being done) won't filter by the dates/months from the DimDate table. I've tried everything I can think of and find online but nothing works so I figured I'd come here and post my own situation.
For reference, I have the exact same relationships to the finances table and have 0 issues there so I'm really unsure what the issue could be.
Relationship between DimDate and WorkOrders:
DimDate table:
Related date field in WorkOrders table
Example visual showing that 41k rows of data aren't being sorted by the date. The date field in this table is the Date field in DimDate table.
Sorry if this is a silly question, I've spent all day stuck on this. Thanks (:
Solved! Go to Solution.
Nevermind, I finally fixed it. I was certain the formats were just date but after converting them to number I could see they weren't so they've since been converted and updated.
Nevermind, I finally fixed it. I was certain the formats were just date but after converting them to number I could see they weren't so they've since been converted and updated.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |