Tableau Measure Names Filter

//

Ever want to use Measure Names as a filter in Tableau? You want to provide a limited selection of measures to choose in the filter instead of all measures?

There is a way to do this:

  1. Set up the worksheet using Measure Names / Measure Values.
  2. In the Measures section, hide the measures that shouldn’t be visible in the filter; right-click on the measure name (or ctrl-click for bulk) and Hide.
  3. Put Measure Names on the filter shelf
  4. Show the Measure Names filter – and only those non-hidden measures will appear
the list of dimensions and measures in tableau
The Measures section is in the box; the fields with a green icon
the data source menu to hide all unused fields
Hide the measures not to appear in the filter

Not able to hide a Measure?

If you right-click on a measure and Hide is greyed out, that means the measure is being used. Only those measures not in use can be hidden.

To resolve this, duplicate the data source and use the duplicate for your Measure Names filter.

If using a hyper extract, there’s no dashboard performance hit (or at least I’m not aware of one) having the same data source connected twice in the workbook. If saving as a twbx, a Tableau packaged workbook, this would clearly increase the size of that workbook.

Obviously, once a measure is hidden, it can no longer be used from that data source.

An alternative to the Measure Names filter is to create a measure selector using a parameter. However, that has the limitation of single selection.

Click through for the interactive report:

a chart with a Measure Names filter
Click through to see the interactive Measure Names filter

2 thoughts on “Tableau Measure Names Filter”

  1. I don’t understand what you mean at step 2 by ‘in the measures section’ which nit of the screen is this?

    Reply
    • Within Tableau Desktop, on the left, the fields in the data source are separated into Dimensions and Measures. That’s what I mean by “Measures Section”.

      Reply

Leave a Comment