Relationship creation for date

[Anonymous]

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?

[v-jingzhang · Accepted solution]

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.

[amitchandak]

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