I'm having a really hard time with the fact that there is no way to show all dates in a PowerPivot table when they have no data. The common solution I find online is to create a measure returning 0 in place of blanks, but this doesn't work for me because my PivotTable row layout is Years > Months > Customer ... and I would want customers to be filtered out that are blank (returning 0's causes every customer to always be returned)... but I do want every month regardless of blanks.
Is there any way to detect that if I am at the month level (or any specific row level for that matter)?
Is there any way to detect that if I am at the month level (or any specific row level for that matter)?