Date Slicer Filter Issue

[AdamMetz23]

Dear Community,

May I ask for help as I run into the following issue.

I have created a date table by using the following DAX formula:

The DIM Date Table is connected to the Fact Table which needs to be filtered based on the Date Table Slicer:

Both Columns are Dates:

When I add the Date column to the slicer, all the data on the page goes blank:

For trouble shooting I compared the two columns next to each other in a table and I can see that all the Date values from the Date DIM table are blanked when I try to match them with the Created Date (Fact Table) column as you can see below:

Have you seen something similar before? I would really appreciate your help. I cannot use Created Date as a date slicer for the report page because I would like to have todays date as latest date in the slicer which is not always in the created date column based on the data source.

Thank you for your suggestion in advance and have a great day,

Adam

[danextian · Accepted solution]

Hi @AdamMetz23 

Try created a calculated column using  isblank(RELATED(datetable[date])) in Azure works table to check if they return non-blank values.

[AdamMetz23]

Thank you for having looked into it.

It turns out the issue was that in Power Query the Azure table date column type was date/time. Once I changed it to Date. It solved the problem with DAX and filtering.

Thank you.

[danextian]

I was going to tell you to look into this datat but your screenshot showed that both columns were dates.

[AdamMetz23]

Hi @danextian ,

Thank you for showing the formula, the suggested confirms that it it returns blank as I have showed in the visualization. 

Do you might know how it can be fixed?

Thank you,

Adam

[danextian]

This is weird. I can see that they're both dates. Can you please do a isblank( LOOKUPVALUE(DatesTable[Date], DatesTable[Date], Azure[CreatedDate]) ) to check if this is still the case?  Also check if the min date in Azure is the same min date in DatesTable.