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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jaleef
Regular Visitor

Date and time slicer issue

hi  have below column which i have exported from dynamic 365

jaleef_0-1621257962485.png

and i have created date table with the following expression 

calendar = ADDCOLUMNS(CALENDARAUTO() ,
"year" , YEAR([Date]),
"monthno" , MONTH([Date]),
"month" , FORMAT([Date],"mm 
jaleef_1-1621258049148.png

 

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

jaleef_2-1621258131221.png

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

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

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

View solution in original post

3 REPLIES 3
HotChilli
Super User
Super User

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
Super User
Super User

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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