I have a dashboard that shows the Measure Names on the Rows shelf and Measure Values as Text. I use a dimension to see the details. I don't want to see values for that dimension if they are 0. Using the Superstore Sales datasource, it looks like this. What I want to do is filter out any Measure Values of 0, but all I can filter is the Measure Names, even when I rightclick Measure Values to Filter. If I add the filter to the specific measure value (in this case "Product Base Margin"), then it will filter out all the customers from all the measures. I just want it to filter out the customers for that particular measure where the value is 0. Any ideas?
The only way I can think of doing this, is to put the measures with 0 values on a separate worksheet and place the 2 worksheets on a dashboard together.