KNOWLEDGE BASE

Incorrect Values on Some Worksheets when Using Synchronized Page Controls


Published: 04 Oct 2017
Last Modified Date: 26 Oct 2017

Issue

When synchronizing the pages control between multiple worksheets on a dashboard, a worksheet that doesn't have a value for the selected page will default back to the first possible page value.

For example, in the attached workbook Maine does not have any sales for 2015. When 2015 is selected in the synchronized page control on the dashboard, then the sales value for Maine remains at its number from the last selection Maine had sales data for.

Environment

  • Tableau Desktop
  • Pages shelf

Resolution

As a workaround, replace the pages control with a parameter that filters the measures in the view.

The attached example workbook uses the sample data set Superstore to demonstrate the following directions:
  1. Remove YEAR(Order Date) from the Pages shelf
  2. Click the down arrow next to Dimensions in the data pane and select Create Parameter…
  3. In the Create Parameter dialog, do the following and click OK:
    • Name the parameter. In this example, it is named "Select Year"
    • For Data Type, select Integer
    • For Allowable values, select List
    • In the list of values, type out all years
  4. Create a calculated field with a name like "Sales per year" with a calculation similar to the following:

    IF YEAR([Order Date]) = [Select Year]
    THEN [Sales]
    END

    This calculation applies the year filter to just the measure [Sales].

  5. Replace [Sales] with [Sales per year] on Text on the Marks card.
  6. Repeat steps 1 & 5 for every worksheet on the dashboard.
  7. On the dashboard, right-click on any worksheet and select Parameters > Select Year.
  8. Right-click the [Select Year] parameter control and select Slider.

Cause

When a particular worksheet has no data for the selected page value, it retains the data from the last relevant page selection.

Additional Information

Note: The parameter will have to be manually updated if new values are added to the data set.
Did this article resolve the issue?