Forum Discussion
Slicers show (blank), but no blanks exist in the data model
My workbook's purpose is to function as a decision tool. Providers select services they offer using a series of slicers. Their responses filter a pivot table, which shows them which license they shou...
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.