Issue
Unable to show only some of the legend items in a visualization
Last Modified Date: 15 Sep 2022
Environment
- Tableau Desktop 2021.4 and newer
Resolution
Workaround
Build a full data worksheet and a filtered data worksheet and then combine them in a dashboard.- Build a normal pie chart in a worksheet and name the sheet Full Pie.
- Create a calculated field Total income: TOTAL(SUM([Income]))
- Create a calculated field test: SUM({ FIXED [Region]:SUM([Income])}) / [Total income]
- Duplicate the worksheet Full Pie as Custom Pie.
- Drag test to the filter. Set whatever range desired.
- Create a dashboard Combined Chart.
- Drag Full Pie and Custom Pie to the dashboard.
- Remove the legend from Full Pie and keep the legend from Custom Pie.
- Float Custom Pie and minimize it somewhere in the dashboard.
Cause
The ability to select a subset of the legend items to display in a dashboard is not currently built into the product.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