cancel
Showing results for 
Search instead for 
Did you mean: 

Show Zero or (-) instead of blank

I know we have the "display rows with no data" option, but the issue with that is it removes any slicer effects as well.

 

Scenario: I have a sales manager report that is filtered by a slicer on "Sales Person". Table shows this persons customers and their spend. If they havnt spent they dont show. Ticking "Show no data" shows every customer regardless of the sales person. 

 

Model: Customer is a dimension with a many to 1 relationship to Salesperson

Status: New