9 Replies Latest reply on Nov 8, 2013 8:41 AM by Josh Pashman

Filtering on a Dual Axis Map

On a Dual Axis Map, can you filter out some dimensions and/or measures on one axis, but keep them on the other?  When I try, it filters out on both maps - somethign I want to avoid.

• 1. Re: Filtering on a Dual Axis Map

Make sure you're not looking at the "All" marks shelf, and that you have selected only the axis you want to filter out. Here's an example:

See how I've selected the individual axis rather than the "All"?

Hope that helps.

Dallin

• 2. Re: Filtering on a Dual Axis Map

Oh, my bad. In my haste to reply I didn't realize you specifically mentioned filters and not marks. Not sure how you'd go about doing that or if it's possible.

• 3. Re: Filtering on a Dual Axis Map

D,

I think you'll need a parameter for both axis that filters conditionally.

• 4. Re: Filtering on a Dual Axis Map

Yea, I am trying various work arounds and nothing seems to work.  It seems like a natural addin.

• 5. Re: Filtering on a Dual Axis Map

Hmmm. How do  I do that?

And to add more complexity - I am working thru a cube.

• 6. Re: Filtering on a Dual Axis Map

Parameter does not appear to be working.

• 7. Re: Re: Filtering on a Dual Axis Map

Hi Josh,

Filters impact on data independently of the configuration of the visualization. This means that if you filter values from a dimension and/or measure, only data under the condition of the filter is going to be displayed in the visual (table, chart, map, etc.)

I think you need to apply other approach, as Allan briefly suggested, based on calculated fields and a parameter.

You can implement this approach creating a parameter, let's say type string, a add a list of values, e.g A, B.

Then create a calculated field that based on the value selected in the parameter, take or transform specific values in a dimension and/or measure.

This is an example of the formula to use:

```IF [parameter]=='A' Then [measure] End
```

Where:

[parameter] is the name of the parameter you created

[measure] is the name of the measure you are showing in the map

It would be good if you post a package workbook with sample data to demonstrate this approach.

I hope this helps,

Best

Ramon

1 of 1 people found this helpful
• 8. Re: Re: Filtering on a Dual Axis Map

Thanks Ramon!

• 9. Re: Re: Filtering on a Dual Axis Map

Ramon -

Thanks.  I am unable to save and share a packaged workbook so it seems.  Working on a connection using a Cube off our server. As a result, Tableau does not want to let me package the data w/out the connection.  Not sure there is a way.

Still a bit confused by your recommendation. Tried and tried, but cannot seem to make it work.

Thanks,

Josh