KNOWLEDGE BASE

How to auto enable/disable horizontal scrollbar according to the dimension size in cross table


Published: 08 May 2023
Last Modified Date: 09 May 2023

Question

How to make cross table fit width with small amount of dimensions while showing scroll bar with large amount of dimensions

When there are few dimentions: (without a scrollbar)
User-added image

When there are many dimentions: (with a scrollbar)
User-added image

Environment

  • Tableau Desktop

Answer

1. Drag [Order Date] to [Columns], [Category] to [Rows], [Sales] to [Text] and [Color] to create a basic cross table
User-added image

2. Double click on blank space in [Columns], enter AVG(1)
User-added image

3. Right click on axis > [Edit Axis] > set [Range] as [Fixed]: start at 0 end at 1
User-added image
User-added image

4. Right click on axis > Uncheck [Show Header]
User-added image

5. Keep [Fit] as [Standard]
User-added image

Additional Information


 
Did this article resolve the issue?