知識庫

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


發佈時間 : 08 May 2023
上次修改日期 : 09 May 2023

問題

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

環境

  • Tableau Desktop

答案

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

其他資訊


 
這篇文章是否解決了問題?