I was unable to open your workbook (try a twbx instead of a twb so as to include the data). However, you should be able to select the pill (green and blue containers up in the column and rows) that contains the measure that has the null values.
- Click the pill
- Select Format
- On the left-hand side of the screen it should have a tab called "Pane"
- In "Pane" at the very bottom there will be a section titled "Special Values"
- Change "Marks:" to the value you would like (i.e. "Hide (connect lines)")
Also, you may be able to add the measure to your Filters shelf. Click on the measure and select "Filter..." Check exclude in the bottom right hand corner and select the values you would like to exclude (it will strike through the text to indicate an exclude.)
I hope this helps. If you have further questions, attach your workbook with the data (twbx).
I have reattached the workbook...hopefully in the correct format. My real problem is that when I remove null values which are shapes (in this case circles), I also remove that region from the filled map. Hopefully it will be clear when the workbook is viewed. Thanks!!
I created a calculated field on the primary data source that referenced the secondary data source and filtered out the nulls using the following expression:
IF NOT ISNULL(SUM([AK_panda (AK_panda.xls)].[mean_APR])) THEN SUM([AK_panda (AK_panda.xls)].[mean_APR])
There was probably a simpler way. But I hope this helps you.
AlaskaCTedit.twbx.zip 67.6 KB