Adding sheets to dashboard in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

How to add multiple sheets to a Tableau dashboard?

You have three sheets: Sales by Region, Profit Trend, and Customer Segments. You want to add all three sheets to a new dashboard. What is the correct way to add these sheets?

A Drag each sheet from the Sheets list on the left into the dashboard workspace one by one.

B Right-click on the dashboard and select 'Add Sheet' to add all sheets at once.

C Double-click on the dashboard background to automatically add all sheets.

D Use the Data menu to import sheets into the dashboard.

💡 Hint

Think about how you usually place sheets visually in Tableau dashboards.

In Tableau, you add sheets to a dashboard by dragging them from the Sheets list on the left side into the dashboard workspace. This allows you to position and size each sheet individually.

🧠 Conceptual

intermediate

Understanding sheet containers in Tableau dashboards

When adding multiple sheets to a Tableau dashboard, what is the purpose of using containers?

A Containers automatically filter data across sheets.

B Containers help group sheets together to control layout and alignment.

C Containers convert sheets into charts.

D Containers delete unused sheets from the dashboard.

💡 Hint

Think about how you organize items visually on a page.

Containers in Tableau dashboards are used to group sheets or objects so you can control their layout, alignment, and spacing together as a unit.

❓ dax_lod_result

advanced

Calculate total sales per region ignoring filters in Tableau

You want to add a sheet to your dashboard that shows total sales per region, ignoring any filters applied on the dashboard. Which Tableau calculation will achieve this?

A TOTAL(SUM([Sales]))

B SUM([Sales])

C WINDOW_SUM(SUM([Sales]))

D { FIXED [Region] : SUM([Sales]) }

💡 Hint

Think about how to fix a calculation at a specific level regardless of filters.

The FIXED LOD expression calculates total sales per region ignoring filters applied on the dashboard, which is what you need.

🔧 Formula Fix

advanced

Why does a sheet not appear in the dashboard after adding?

You dragged a sheet into your Tableau dashboard, but it does not appear. What is the most likely reason?

A The sheet is hidden because the container size is too small or collapsed.

B The sheet data source is disconnected.

C The dashboard is in presentation mode.

D The sheet is filtered out by a dashboard filter.

💡 Hint

Check the dashboard layout and container sizes.

If the container holding the sheet is too small or collapsed, the sheet will not be visible even though it is added to the dashboard.

🎯 Scenario

expert

Optimizing dashboard performance with multiple sheets

You have a dashboard with five sheets showing different sales metrics. The dashboard loads slowly. Which approach will best improve performance while keeping all sheets visible?

A Increase the size of all sheets to fill the dashboard space.

B Add all sheets as live connections without extracts.

C Use dashboard actions to filter sheets dynamically instead of showing all data at once.

D Remove containers to simplify the layout.

💡 Hint

Think about reducing data load and improving interactivity.

Using dashboard actions to filter sheets dynamically reduces the data each sheet loads, improving performance while keeping all sheets visible.