Slicer appear blank values

[Gokul_G16]

Dear Folks,

I would like to share one scenario here, In Dim table having unique location while import in slicer, it shows in dropdown appear blank also. There is blank in my dim table. How it be show's over the slicer along.

Thanks 
Gokul

[Thennarasu_R]

Hi @Gokul_G16 
Obviouslly I will happen so, we need Relationship and hide Blank using visual level filter.suppose while hide blank not affect your the your output . you could use this ine also.

Thanks,
Thennarasu

[LQuedas]

Hey @Gokul_G16 ,

this situation usually happen when you have facts in the fact table without a key to the dimension you are using to Slice the report. Check the relationships between the Dim and the Facts used and have sure all the forigner keys of the Fact exist in the Dimension.

Hope this helps.

Cheers, LQ