cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Relationship creation for date

Hi,

 

I have created a table with Dates from the past 3 days and wanted to create a relationship between that table and another one of my tables. However, after creating the relationship, everytime i utilise the slicer with the dates, it just shows nothing even though there are data for it. Can anyone help me with this issue?

 

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @Anonymous 

 

What are the data types of Dates columns in both tables? Date or Datetime? If they are datetimes, do they have different time values? If they have different time values, you will probably see blank when using a slicer because it cannot find datetime values that are equal to the selected one in the slicer.

 

If you want to filter on dates, you could add an additional column which extracts only date values from the datetime column, and create a relationship on the new date column. If you don't need to use time values in this report, you could change the original datetime column to date type. But in this way the time values will be removed so ensure that you won't need them in the future if you do this. Otherwise adding an additional date column would be better.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @Anonymous 

 

What are the data types of Dates columns in both tables? Date or Datetime? If they are datetimes, do they have different time values? If they have different time values, you will probably see blank when using a slicer because it cannot find datetime values that are equal to the selected one in the slicer.

 

If you want to filter on dates, you could add an additional column which extracts only date values from the datetime column, and create a relationship on the new date column. If you don't need to use time values in this report, you could change the original datetime column to date type. But in this way the time values will be removed so ensure that you won't need them in the future if you do this. Otherwise adding an additional date column would be better.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

View solution in original post

amitchandak
Super User
Super User

@Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!