Line charts in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the correct use of a dual-axis line chart

You have two measures: Sales and Profit Margin. You want to show their trends over time on the same line chart but with different scales. Which option correctly describes how to create this visualization in Tableau?

A Place both measures on Columns shelf and use the 'Show Me' panel to select a line chart.

B Place both measures on Rows shelf, right-click the second axis and select 'Dual Axis', then synchronize axes.

C Create two separate worksheets and place them side by side on a dashboard.

D Combine both measures into one calculated field and plot it on a single axis.

💡 Hint

Think about how Tableau allows overlaying two measures with different scales.

Option B correctly describes the process to create a dual-axis line chart in Tableau, allowing two measures with different scales to be shown together.

❓ dax_lod_result

intermediate

Calculate running total for sales over months

Given a sales table with columns Month and SalesAmount, which DAX measure correctly calculates the running total of sales by month?

A Running Total = CALCULATE(SUM(Sales[SalesAmount]), FILTER(ALL(Sales[Month]), Sales[Month] <= MAX(Sales[Month])))

B Running Total = SUMX(FILTER(Sales, Sales[Month] >= MIN(Sales[Month])), Sales[SalesAmount])

C Running Total = SUM(Sales[SalesAmount])

D Running Total = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[Month] >= MAX(Sales[Month])))

💡 Hint

Consider how to accumulate sales up to the current month.

Option A uses CALCULATE with FILTER and ALL to sum sales up to the current month, correctly computing the running total.

❓ data_modeling

advanced

Optimizing data model for time series line charts

You want to create a line chart showing monthly sales trends for multiple product categories. Your current data model has a large sales fact table and a separate date dimension table. What is the best modeling practice to optimize performance and accuracy for this line chart?

A Remove the date dimension table and use only the date column in the sales fact table.

B Duplicate the sales fact table and join it with the date table on the month name text field.

C Ensure the date dimension table is marked as a Date Table and create a relationship with the sales fact table on the date key.

D Create a calculated column in the sales table to convert dates to text and use it for filtering.

💡 Hint

Think about how date tables improve time intelligence calculations.

Marking the date dimension as a Date Table and relating it properly ensures efficient time-based calculations and filtering for line charts.

🔧 Formula Fix

advanced

Fix the issue with missing data points in a line chart

You created a line chart showing monthly sales, but some months are missing from the line, causing breaks. What is the most likely cause and fix?

A The date dimension table is missing some months; add all months to the date table to fix it.

B The sales data has null values; replace nulls with zeros in the sales column.

C The line chart is filtered by product category; remove the filter to show all months.

D The axis is set to categorical; change it to continuous to show all months.

💡 Hint

Consider how Tableau or BI tools treat date axes in line charts.

Setting the axis to continuous ensures all dates appear on the axis, preventing breaks in the line chart.

🎯 Scenario

expert

Designing a dynamic line chart with user-selected measures

You want to build a line chart dashboard where users can select which measure to display (e.g., Sales, Profit, Quantity). Which approach best supports this dynamic selection in Tableau?

A Create a parameter listing all measures and use a calculated field with CASE to switch measures based on the parameter value.

B Create separate worksheets for each measure and use dashboard actions to show/hide them based on user clicks.

C Use a filter on the measure field to let users select the measure to display.

D Create a calculated field that sums all measures and plot it as a single line.

💡 Hint

Think about how parameters and calculated fields can create dynamic visuals.

Using a parameter with a calculated field allows switching the measure dynamically in one worksheet, making the dashboard interactive and efficient.