Forum Discussion
Slicer appear blank values
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
2 Replies
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
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
