BASE DE CONNAISSANCES

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


Date de publication : 08 May 2023
Date de dernière modification : 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

Environnement

  • Tableau Desktop

Réponse

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

Informations supplémentaires


 
Cet article vous a-t-il permis de résoudre le problème ?