Use Dynamic Axis Ranges

It’s key that your users understand the range represented in a viz so that they can correctly analyze the data. Especially when analyzing multiple vizzes in a dashboard or multiple worksheets at the same time, it can be easy for users to misinterpret data when the range of the axes is different between vizzes. For example, when two bar charts appear next to each other, the bars in both charts might appear to be equivalent sizes. However, the axes might have very different ranges, making the charts misleading.

To help users understand the range of the axis, in 2023.3 and later, authors can use Dynamic Axis Ranges to set the minimum and maximum values of an axis range by using numeric parameters or date parameters. Then, as users navigate across vizzes, the axes update synchronously. This makes it easier for your users to analyze data across vizzes easily and accurately. And by limiting the range of the data, you can view a subset of data without filtering the underlying data or impacting the moving average of your data.

Dynamic Axis Ranges can also be used to extend or shorten the range of an axis without filtering out the underlying data. This is ideal for showing progress against a goal or showing a moving average.

Supported field types

Dynamic Axis Ranges support any parameter that is compatible with the selected continuous axis, for example:

  • Numeric parameters
  • Temporal parameters (date or dateTime)

Configure a dynamic axis range

  1. From a Tableau sheet, create a parameter for your axis.
  2. Right-click the axis, and choose Edit Axis.
  3. For the Range, choose Custom. Then, select the parameter that you created for either the start or end axis extent.
  4. Close the dialog box.
  5. If you’re using multiple sheets on a dashboard, repeat these steps for the axes across the different sheets.

An animation that shows a parameter used to create a dynamic axis range, and then the animation shows how filtering is affected by dynamic ranges.

Understand limitations and edge cases

Dynamic Axis Ranges aren’t updated within Stories. If the parameter used for the axis is deleted, then the most recent parameter value remains as the axis extent. The next time you edit the axis, an error message will prompt you to choose a new parameter to be used.

Thanks for your feedback!Your feedback has been successfully submitted. Thank you!