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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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