blank value in slicer

[Anonymous]

Hi,

I have a date table which i have joined with my fact table. I am using trying to use year month field as a slicer which i created in the date table, however when the slicer does not work when i select any value other than blank. can someone please help in isolating what going on here ? secondly why is blank value even coming up when i am using it in slicer , i checked the date table is not missing any date. i have tried to recreate the tables as well and it didnt work.

[v-gizhi-msft]

Hi,

Please check your repaltionship direction is both instead of single.

Best Regards,

Giotto

[Anonymous]

Hi,

@v-gizhi-msft It was single then i changed it to both however the issue remains. 

@Greg_Deckler  good one 😄

[Anonymous]

@v-gizhi-msft  can someone from microsoft help me here, i am sure this is a very common scenario.

[v-gizhi-msft]

Hi,

Could you please share your file by OneDrive for Business?

Remember to move any sensitive data.

This will let me help you further.

Best Regards,

Giotto

[mahoneypat]

The blank row shows up when there is at least one unmatched value in the fact table.  In your case, it seems like none of them are matched.  I would check for a type mismatch between the two tables.  Is one a DateTime instead of Date?

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

Hi,

both fields are datetime.

[Greg_Deckler]

Blanks in slicers means that there are rows in a relationship that are non-matching. Sounds like your relationship is messed up. Not that I am one to talk, I've been divorced twice! So, you know, not judging... 🙂