KNOWLEDGE BASE

How to fix the axis range regardless of the filter


Published: 20 Oct 2022
Last Modified Date: 21 Oct 2022

Issue

How to fix the axis range regardless of the filter.

<Current behavior>
When the filter is changed, the axis scale changes.
User-added image

<Desired behavior>
Changing the filter does not change the axis scale.
User-added image

Environment

  • Tableau Desktop

Resolution

Can be achieved by using a reference line.

<STEP 1 -Create a view->
1. Connect to Sample -Superstore.
2. Drag [Order Date] to Columns and [Sales] to Rows.
3. Drag [Region] to Filter Pane
4. Right click on [Region] -> Show Filter.

<STEP2 -Add a reference line->
5. Create a new calculated field as following.
     Name : Max Window Height
     Calculation : {FIXED DATEPART('year', [Order Date]):SUM([Sales])}
6. Drag [Max Window Height] to Detail on Marks.
User-added image
7. Right click on axis of Sales -> Add Reference line
User-added image
8. Set as following.
User-added image
 

Cause

This feature is not built in Tableau Desktop yet.
Did this article resolve the issue?