Value showing as blank in date slicer when all dates are present

[Anonymous]

I set up a measure to count all rows on a sheet which was working perfect before today. I have a filter on the page for years that filters out all the values with blank for year. A new row was added to the sheet and for some reason it is being filtered as a blank year when its has the year and a realationship with a date table.

This is the new row 

This is the date table

Both date columns are set to date 

Why has this suddenly started when it has been working fine for the last 2 months when i first made it?

[Anonymous · Accepted solution]

The problem was that when I import the data it comes as date/time and previously all the time had values of 00:00:00 but this new data had more specific time so no longer could link to any of the date table as they all had a default time of 00:00:00. All i had to do is make a new column that copied just the date and not the time and the relationship between the date table work again

[CheenuSing]

Hi @Anonymous ,

Is there by any chance there are records in table 1 prior to June 2022, which is not available in Date Table.

Check out the link, if it helps

Solved: Seeing BLANKS in Slicer even though there are no B... - Microsoft Fabric Community

Cheers
CheenuSing

[Anonymous]

No definetly not, that intake sheet (table 1) has rows for new projects but once the project gets assessed and asigned that row is moved to the active sheet so rows are never there for more than a week. that row is the only row currently in the table. We only started this in october in 2022 so there are no dates before that at all in our data

[Anonymous]

Hi CheenuSing 
This is the first table, there are extra columns with mostly blank values as the way its set up is rows dont stay on this sheet for long before they are moved to an active sheet where the rest of the columns are filled in

This is the date table

This is the only realationship between the 2 tables

[CheenuSing]

Hi,

Can you share the tables and the relationship between the tables.

Cheers

CheenuSing