Customizing the appearance of a straight table
Under Appearance in the properties panel, you can change the functional appearance of a straight table. For example, you can add a hover menu, turn on pagination, and apply text wrapping.
Other aspects of the straight table's appearance can be customized with styling. For more information, see Styling a straight table.
Turning on the hover menu
Under Appearance > General, use the toggle for Show hover menu to choose whether you want the hover menu to display in the visualization.
Showing details
Under Appearance > General, set Show details to Show if you want to allow users to be able to choose to view details, such as descriptions, measures, and dimensions.
Allowing users to view expressions in the chart
Under Appearance > General, set Show expressions to Show if you want to allow users to be able to choose to view expressions.
Using pagination
Under Appearance > Presentation, turn on the Use pagination setting to change how many rows are displayed in the chart. With pagination, instead of displaying all rows at once, only a certain amount of rows are displayed. Users can use the arrow buttons at the bottom of the table to navigate.
Using text wrapping
When text in the straight table is too long to be displayed given the provided space, some text is not shown and instead represented with an ellipsis. Under Appearance > Presentation, you can use the settings under Multiline text wrapping to wrap the text over multiple lines in the table. This setting can be controlled individually at the header and cell levels:
-
Wrap text in headers (table headers only)
-
Wrap text in cells (table cells only)
Styling panel. See Customizing the grid.Customizing representation of null values
You can change how null values are represented for measures in the straight table. Enter static text to be used to replace null values. When you use numeric values, these values are interpreted as numbers rather than text. This allows you to fill in missing calculations with actual values, such as 0.
Do the following:
-
Click Appearance > Presentation in the properties panel.
-
Under Null value text, enter the text that will replace null measure values.
Hiding the column header
You can hide the header at the top of the straight table that displays column titles and allows user to change the sorting. Under Appearance > Presentation, activate the Hide header setting.