Forum Discussion
Slicers show (blank), but no blanks exist in the data model
That could be incorrect relationships. Or missing foreign key in dimension table. Perhaps something else, but in any case that's better to discuss on sample file.
Thanks for your reply. I apologize, but I cannot figure out how to attach a sample file in this thread - is it something I need to provide a link to? Or would a series of screenshots showing relationships in the data model be preferred?
Again, you are to be sure keys in fact table(s) are not missed in dimension table. Simple case - you have dimension table Date with all dates in years from 2024 to 2026. But in fact table Sales you have transaction for December 2023. In ths case slicer will be with blank row. You may chack that yourself. File is to check what could be else if above is not the case.