Question
Is it possible to hide only the rows that contain null in a particular column?
For example, if we would like to hide only the null row for the Manufacturer of "3M" in the following view, how can it be achieved?
Last Modified Date: 17 Jan 2024
Environment
- Tableau Desktop
Answer
Follow along in the sample packaged workbook found in the Attachments section to review the steps below.1. Add Manufacturer to Columns.
2. Add Category and Sub-Category to Rows.
3. Add SUM(Sales) to Text.
4. Right-click Manufacturer in the Data pane and select Create > Set. Name it Select Manufacturer to Exclude Null Rows.
5. Add Sub-Category to Filters shelf. Open Condition tab, choose By formula: option, and enter the following formula.
MAX([Select Manufacturer to Exclude Null Rows]) AND NOT ISNULL(SUM([Sales]))
6. Right-click Select Manufacturer to Exclude Null Rows in the Data pane, and select Show Set.
7. Change the set control to single-value selection mode from the following location.
8. Select any value in the Select Manufacturer to Exclude Null Rows set control. Then, null rows are hidden in the selected Manufacturer column.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials