Tableau KPI Visualization: Category Sales, Percentage of Total, and Trends
Create a Tableau KPI card for a dashboard that displays category sales, percentage of total, and trend sparklines all within a single worksheet. Category labels and sales amounts are formatted in rounded corner containers, while donut charts represent each category’s share of total sales, adding a visual breakdown.
A second worksheet features dynamic trend bars with alternating colors, achieved using a discrete INDEX() field and category fields. This ensures consistent color alternation, even when filters or x-axis ranges (like months to quarters) change. This setup delivers an interactive, visually engaging view of category sales metrics, sparklines, and total contributions for a complete Tableau dashboard experience.
Tableau: https://public.tableau.com/app/profil...
Excel: https://docs.google.com/spreadsheets/...
Rounded Box: https://drive.google.com/file/d/1bOzg...