Did you know that Tableau Desktop has the option to filter the data pane by field types on top of just their names? With the introduction of data models in Tableau Desktop, I see a lot of users frustrated with the seemingly crowded data pane. Before the data model, you used to have dimensions and measures in separate sections in the data pane, but now everything is grouped by tables of your data source. The good news is that Tableau actually still has an intuitive way to quickly see the fields you need.
As of 2020.3 you can filter your searches by 4 different queries:
C: filters for calculated fields
M: filters for measures
D: filters for dimensions
F: filters by comments
By typing C: or any of the other options at the beginning of your search, you’ll filter all of the fields based on that category. After the type filter, just put the field name you’re looking for to filter further.
There are technically two ways to filter your searches. You can manually type in the values above, or you can use the filter button located to the right of the search bar. Take a look at the GIF below to see.
That’s all there is to it! Tableau has some great documentation on further things you can do in the data pane as well, take a look: https://help.tableau.com/current/pro/desktop/en-us/datafields_dwfeatures.htm
This has been a quick tip that will hopefully make your Tableau Desktop development workflow a little easier. Make sure to check out the other quick tip articles to level up your development!
- Game-changing features in Tableau Online 2021.2
- Quick Tip: How to develop more efficiently with big data sets Tableau Desktop
- Quick Tip: The MAKEDATE Function in Tableau Desktop
- Quick Tip: Hide the Null indicator in Tableau Desktop when you don’t want to filter the data
- The hardest part about making dashboards for Tableau Public
If you found this post helpful, subscribe below! I’ll be releasing some tutorial videos soon, and my subscribers will be the first to see them!