Forum Discussion
lrroberts
Apr 21, 2026Copper Contributor
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...
Hecatonchire
Apr 21, 2026Iron Contributor
Hello
Try this : Set "None" here (PivotTable options) and refresh ?
lrroberts
Apr 22, 2026Copper Contributor
That option is grayed out for me, I believe because the pivot table is derived from the data model. Please let me know if there's something I'm missing though! I appreciate your suggestion.