date table is not filtering sales

[powerbiexpert22]

somehow not sure date table is not filtering sales table and i am unable to create bar chart to show sales by year,

sales table is joined based on order date and datedim table is created from min and max values of order date

please see below screenhsot and sample pbix file

https://drive.google.com/file/d/1UDKJkjubwV70b-Mx5bb0EmA99vm8ppD6/view?usp=drive_link

[MasonMA · Accepted solution]

Hi

Your Order Date contains time as well. To have DimDate filter Fact table, both columns would need to be only Date. But this cannot be done by only changing the Order Date column’s format in the data view or model view, as the underlying values still include the time portion. Since i'm not able to transform your Data in Power query, i created one date column from Order Date. and rebuild the relationship. 

Date =

DATEVALUE(Sales_Orders[OrderDate])

[d_m_LNK]

To start with something simple, this seems like an issue with the relationship and potentially data type mismatch. Are both the order date and date in the date table set to the same data type?  I would check the order date data type first.