Last Modified Date: 27 Jul 2017
Use INDEX() on Color on the marks card, rather than the original dimension.
The attached example workbook uses the sample data set Superstore to demonstrate the following instructions:
- Drag [Customer Name] from Color to Detail on the marks card
- Create a calculated field with a name like "Index" with a calculation similar to the following:
- Drag [Index] to Color on the marks card.
- Right-click [Index] on the marks card and select Edit Table Calculation...
- In the Table Calculation dialog, do the following and click the "x":
- Select Specific Dimensions.
- Check both Customer Name and Regions.
- Reorder the dimensions so that Customer Name is first.
- For At the level, select Customer Name.
- Click on Color on the marks card and click Edit Colors.
- In the Edit Colors dialog, assign colors as desired.
Additional InformationNote: The above solution will not work correctly with a continuous date field in the view as Tableau Desktop will use this date when computing INDEX().
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials