Reference bands in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Purpose of Reference Bands in Tableau

What is the main purpose of adding a reference band to a Tableau visualization?

A To filter data points outside a specific range

B To highlight a range of values between two reference lines for better comparison

C To change the color scheme of the entire chart

D To add labels to individual data points

💡 Hint

Think about how reference bands help viewers understand data ranges visually.

Reference bands visually highlight a range between two values, making it easier to compare data within that range.

❓ dax_lod_result

intermediate

Reference Band Calculation Result

Given a Tableau reference band set between the average sales of $500 and $1000, what will be the color of data points with sales of $750 if the band color is blue?

A Blue

B Red

C No color change

D Green

💡 Hint

Reference bands color the background band, not the individual data points.

Reference bands only color the shaded area between the reference lines; data points keep their assigned mark colors regardless of position.

❓ visualization

advanced

Best Practice for Reference Band Placement

Which placement of a reference band in a sales over time line chart best helps users identify periods of high sales?

A Between the minimum and median sales values

B Between the median and 25th percentile sales values

C Between zero and the average sales value

D Between the 75th percentile and maximum sales values

💡 Hint

Think about highlighting the top sales periods.

Placing the reference band between the 75th percentile and maximum highlights the highest sales periods clearly.

🔧 Formula Fix

advanced

Why Reference Band Does Not Appear

A user adds a reference band between fixed values 100 and 200 on a scatter plot, but the band does not show. What is the most likely reason?

A The data points' values are all outside the 100 to 200 range

B The reference band color is set to transparent

C The axis is not continuous

D Reference bands cannot be added to scatter plots

💡 Hint

Check if the band range overlaps the data range.

If all data points fall outside the band range, the band will not be visible on the plot.

🎯 Scenario

expert

Using Reference Bands to Highlight Performance Targets

You have monthly sales data and want to highlight months where sales were between the target minimum of $8000 and target maximum of $12000 using a reference band. Which steps correctly create this in Tableau?

A Add a reference band on the sales axis with fixed values 8000 and 12000, set band color to light green, and ensure the axis is continuous.

B Add a reference line at 8000 and another at 12000, then color data points between them manually.

C Create a calculated field to filter sales between 8000 and 12000 and use it as a filter instead of a reference band.

D Add a reference band with dynamic values based on average sales, ignoring fixed target values.

💡 Hint

Think about how to visually highlight a fixed range on the axis.

Adding a reference band with fixed values and a distinct color on a continuous axis highlights the target range clearly.