Date and time slicer issue

[jaleef]

hi  have below column which i have exported from dynamic 365

and i have created date table with the following expression 

calendar = ADDCOLUMNS(CALENDARAUTO() ,

"year" , YEAR([Date]),

"monthno" , MONTH([Date]),

"month" , FORMAT([Date],"mm 

and i have created relation with date and cretaed on but when i am using the slicer 

cases are not getting filtered .  or is there better way anyway to create a dynamic 365 dashboard in powerbi

[HotChilli · Accepted solution]

Is the time in the 'created on' field important?  If not then set the data type to be Date.

If it is, you'll need to think about it more carefully.

If you want, you can duplicate the column , set the data type to Date and use that in the relationship

[HotChilli]

looks like the relationship is a date on one side and a datetime on the other so there won't be any matches

[jaleef]

how can i resolve that , changing the format is not helping