0

I am working with a dual axis map in Tableau and I am displaying one measure as color density on the map and another measure as bubbles on the same map.

The 2nd measure has null values - but the null values display as very little dots in the map. Is there any way to exclude them?

I tried to filter the 2nd measure to exclude null values, but then the first measure is filtered the same way.

Tableau example

jeangelj
  • 4,338
  • 16
  • 54
  • 98
  • You can try making a new calculated measure of: `IF [YOUR MEASURE] = >0 THEN [YOUR DIMENSION] END` This won't contain any values less than 0, if you use this in place of your current field it should remove the small blobs. – Ben P Jul 25 '17 at 15:53
  • 1
    Another option for this, create a measure using ISNULL: `IF ISNULL([YOUR MEASURE]) THEN "Nulls" ELSE "Not Null" END` Then drag this onto the filters shelf to exclude the nulls from this dimension only. – Ben P Jul 25 '17 at 16:07
  • I tried the first option and it works the same way as the filter, it does make the little bubbles dissapear, but also the colors for those counties – jeangelj Jul 25 '17 at 19:40
  • Post a subset of your data – Alex Blakemore Jul 26 '17 at 01:01

0 Answers0