Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date and time slicer issue

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

data protection
Need Help
Show and Tell
Tips and Tricks
  • HotChilli's avatar
    HotChilli
    5 years ago

    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

3 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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