Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
HPoyzer
Frequent Visitor

Measures won't filter by related date table

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:

HPoyzer_0-1699970325018.png

 

DimDate table:

HPoyzer_1-1699970362598.png

Related date field in WorkOrders table

HPoyzer_2-1699970709576.png

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.

HPoyzer_3-1699970828285.png

 

Sorry if this is a silly question, I've spent all day stuck on this. Thanks (:

 

 

 

1 ACCEPTED SOLUTION
HPoyzer
Frequent Visitor

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. 

View solution in original post

1 REPLY 1
HPoyzer
Frequent Visitor

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. 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

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.