Blank Values in Slicer

[DivakarKrishnan]

Dear Team,

I am getting blank values in Slicer, I have thoroughly verified the data between two related tables but I didn't see missing data.

I dragged the related field into table and verified the data to see if any data is missing in relationship but I couldn't find any data related to this blank in slicer.

Is there any other way to find out the missing data in the relationship?

Thanks,

P.K.Divakar

[Fowmy · Accepted solution]

@DivakarKrishnan 

This usually happens when you have values in the fact table but not present in the dimension table. Check the following video:

https://www.youtube.com/watch?v=23qemkDqMVY

https://www.youtube.com/watch?v=XsyeImIK-7g