Pie charts in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the Correct Pie Chart Setup

You want to create a pie chart in Tableau showing sales distribution by region. Which step is essential to ensure the pie chart displays correctly?

A Drag the 'Region' dimension to Color and 'Sales' measure to Angle on the Marks card.

B Drag the 'Sales' measure to Rows and 'Region' dimension to Columns, then select Pie chart type.

C Place 'Region' on Filters and 'Sales' on Tooltip, then select Pie chart type.

D Drag 'Sales' to Color and 'Region' to Size on the Marks card.

💡 Hint

Think about how Tableau uses the Marks card to build pie charts.

In Tableau, to create a pie chart, you must assign the dimension to Color and the measure to Angle on the Marks card. This splits the pie slices by the dimension and sizes them by the measure.

🧠 Conceptual

intermediate

Best Practice for Pie Chart Usage

Which of the following is best practice advice when using pie charts in business intelligence dashboards?

A Limit pie charts to show no more than 5-6 slices for clear visual comparison.

B Avoid labeling slices; users can guess the values by slice size.

C Use pie charts to compare many categories with similar values for detailed analysis.

D Always use 3D pie charts to make the chart more visually appealing.

💡 Hint

Think about how easy it is to compare slice sizes visually.

Pie charts are most effective when showing a small number of categories. Too many slices make it hard to compare sizes and reduce clarity.

❓ dax_lod_result

advanced

Calculate Percentage for Pie Chart Slice

You want to create a calculated measure in Tableau to show each category's percentage of total sales for a pie chart. Which formula correctly calculates this percentage?

A SUM([Sales]) / AVG([Sales])

B SUM([Sales]) / TOTAL(SUM([Sales]))

C SUM([Sales]) / SUM([Sales])

D SUM([Sales]) / WINDOW_SUM(SUM([Sales]))

💡 Hint

Consider how Tableau calculates totals across the current partition.

WINDOW_SUM(SUM([Sales])) calculates the total sales over the current window, allowing the formula to compute each slice's percentage of the total.

🔧 Formula Fix

advanced

Troubleshoot Pie Chart Showing Single Slice

You created a pie chart in Tableau, but it shows only one slice instead of multiple slices by category. What is the most likely cause?

A The pie chart type is not selected from the Show Me panel.

B The dimension used for Color is missing or not on the Marks card.

C The data source has no sales values.

D The measure used for Angle is not aggregated.

💡 Hint

Think about what controls the slice division in a pie chart.

If the dimension that splits the pie slices is missing or not assigned to Color, Tableau treats the data as one group, showing a single slice.

🎯 Scenario

expert

Designing an Accessible Pie Chart Dashboard

You are designing a dashboard with pie charts for a diverse audience, including colorblind users. Which approach best improves accessibility while maintaining effective data communication?

A Use many similar colors to differentiate slices and rely on tooltips for details.

B Use only shades of one color and no labels to keep the chart simple.

C Use distinct colors with high contrast and add data labels showing percentages on each slice.

D Use 3D pie charts with shadows to make slices stand out visually.

💡 Hint

Consider color contrast and alternative ways to convey information besides color.

Using distinct, high-contrast colors helps colorblind users distinguish slices. Adding data labels with percentages provides clear numeric information beyond color.