Skip to main content Skip to complementary content

Filter pane properties

You open the properties panel for a visualization by clicking @Edit in the toolbar and clicking the visualization that you want to edit.

If the properties panel is hidden, click h in the lower right-hand corner to open it.

Information noteIf the visualization has é in the upper right-hand corner, the visualization is linked to a master item. You cannot edit a linked visualization, but you can edit the master item. You can also unlink the visualization to make it editable.

Data

Click Add to add a dimension or create a dimension from a field. If the option is dimmed it is not available.

Dimensions

Add dimension

On the Data tab, under Dimensions, click Add to open a list of available Dimensions and Fields. Select the dimension or field that you want to use.

You can also click 3 to create a dimension in the expression editor. To be able to edit a dimension that is linked to a master item, you must first unlink the dimension. Another way to create a dimension is to type the expression directly in the text box. Expressions added in this way must begin with an equals sign (=). Here is an example with a calculated dimension:

=If (Week < 14, Week, 'Sales')

If Add is dimmed, you cannot add more dimensions.

<Dimension name> Click the dimension name to open the dimension settings. If you want to delete the dimension, long-touch/right-click the dimension and select Delete in the dialog. Alternatively, click the dimension and click DeleteÖ.
Dimension Only displayed for master items. To be able to edit a dimension that is linked to a master item, you must first unlink the dimension.
Field

If you have added a field from Fields in the assets panel, the field name is automatically displayed. If you change the field, the dimension name is automatically updated. Click 3 to open the expression editor.

Title Enter a title for the dimension. If you have added a field from Fields in the assets panel, the field name is automatically displayed.

You can drag the dimensions to set the order in which they are displayed in the visualization. Use the drag bars (o) to rearrange the order.

Sorting

By default, the dimensions are sorted in the order they were added, with the most recently added dimension last. For filter panes, you change the sorting order of the dimensions under Dimensions in the Data section. Drag the dimensions to change the order. Under Sorting you can change the internal sorting of the dimensions.

Each dimension is sorted internally in the most common way for that type of data. Numbers are sorted numerically, ascending. Text is sorted alphabetically, ascending. If you want to change the internal sorting of a dimension, click the sorting button. The following table shows the internal sorting priority order and sorting options. The sorting is either Ascending or Descending.

Sorting

Sort by expression: Enter an expression to sort by. Only available for dimensions.

Sort by frequency: Only available for filter panes.

Sort numerically

Sort alphabetically

Additionally, you can sort by load order by switching to Custom and leaving all sorting options unselected.

If you have set a custom order for a field, that custom order will override any selected internal sort order in Sorting. See Customizing the order of dimension values.

Appearance

General

Show titles: On by default in all visualizations except filter panes, KPIs, and text & image visualizations.

Enter Title, Subtitle, and Footnote. By default, the string is interpreted as a text string. However, you can also use the text field for an expression, or a combination of text and expression. An equals sign (=), at the beginning of a string shows that it contains an expression.

Click 3 if you want to create an expression by using the expression editor.

Example:  

Assume that the following string is used, including quotation marks: 'Sales: ' & Sum(Sales).

By default, the string is interpreted as a text string and is displayed as presented in the example. But if you begin the string with an equals sign: (='Sales: ' & Sum(Sales)), the string is interpreted as an expression instead. The output is then Sales: <value of expression>, where <value of expression> is the calculated value.

Show details: Set to Show if you want to allow users to be able to choose to view details, such as descriptions, measures, and dimensions.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!