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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.