Issues with relationships and filtering by date table

[Anonymous]

I am having little success in trying to filter my data using my date table.

I have two tables - one contains a list of IT support tickets, with two date fields: 'Date of creation', and 'Date of closure'.

The other is a date table generated via a CALENDARAUTO DAX script.

Following the instructions that I have found in other Power BI threads, I have created a relationship between 'Date of creation' in the tickets table, and 'Date' in the date table. I have ensured that the data categories match (Date), and that the format also matches (dd/MM/yyyy).

The relationship is active, and many (incidents table) to one (date table).

Despite this, once the relationship is created and I add a slicer to filter my dataset, the value constantly appears as blank. Whatever I try, I am completely unable to filter my data using the linked date table.

Does anyone have any experience with this and/or ideas what might be going wrong?

[v-frfei-msft]

Hi @Anonymous ,

Could you please share your pbix to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

Regards,

Frank

[Anonymous]

This is happening to me also.

@v-frfei-msft

All the tables I lay out and create relationships for do not work anymore.  The first screenshot is using the date filter from my date table along with relative data from a linked table.  You will see the data in the bottom visual disappears. 

The second screenshot is where the date filter is removed and the data appears (I had to change the field as I did not want to publish employee names.)

The third screenshot is just a snap of my tables.  This setup has ALWAYS worked in the past, so not sure what is happening here.

[Anonymous]

post screenshot,,,it will make it easy understanding ur issue and to give the solutions