I have a powerpivot table which groups customers into ranges of sales figures. When I use a slicer to slice by region, I lose some of the ranges because they contain no data. I need them to show up even if there is no data. I've checked all of the boxes to "Show items with no data on columns (and Rows). But this has no effect. I created a measure using the following formula which also has no effect.
NeverBlankAcct:=IF(ISBLANK(Count([CACCT])),0,Count([CACCT]))
I have examples of the tables, but this forum wont let me post them (keep getting internal server error). I've searched everywhere and cannot find a solution that will work for me. Any help greatly appreciated.