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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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