Edit the style of a widget

The style of a widget can be edited using the Style editor. This can be accessed from the Tools panel, next to the data model on the left of the application. Open the Style editor by clicking its icon (the paint roller).

Different aspects of a widget can be modified depending on its type, for example you can change the size of a table, or add axis titles to a chart, therefore the Style editor will contain different sections depending on the type of the selected widget.

note

The Style editor tool is available for all widget types except gauge and bullet charts.

Format values

You can choose the format of display for numerical values on a per measure basis.

• Select a measure from the dropdown at the top of the Style editor.
• Choose the format of display from the next dropdown. The default is Number, the other options are Percentage, Thousands, Millions and Billions.
• You can also use the red and green arrows next to the dropdown to control how many decimal places are shown for the values of the chosen measure.

note

On charts, formatting the numbers will change the value displayed in the tooltip when hovering a chart point, and on the Data labels if you have enabled these.

Conditional styles

A conditional style can be applied conditionally to a widget, depending on the value of a member. In the Conditional styles section of the Style editor, you can add rules which will apply a color only to the members which fulfill the requirements, for example you could choose to highlight in green all members with a value greater than 0. How this color is applied will depend on the widget type.

Chart type	Applied to
Table	Table cells
Line/radar chart	Chart points
Column chart	Columns
Bar chart	Bars
Pie/Donut chart	Sectors

Add a conditional style

To add a conditional style:

• If your widget has more than one measure, select the measure on which you wish to apply the conditional style from the dropdown at the top of the Style editor.
• Click the + icon next to the title Conditional styles, this will open a popup containing some inputs and a color palette.
• Use the first dropdown to create your rule and the input box next to it to specify a value. For example, if you want to highlight all cells less than 0, choose is lower than from the dropdown and enter 0 in the input box.
• Optionally add a second condition to your rule using the second dropdown and input.
• Choose a color from the color palette.
• Click Apply style.

Conditional styles are displayed as tiles in the Style editor. Their rules are applied in the order of the tiles, from top to bottom, with each new rule taking priority over any previous rules. For example, if I have a measure with the values 15 and 25, if I first add a rule where values > 10 are blue, then add a rule where values > 20 are green, 15 will be blue and 25 will be green. However if I had added the second rule first, both values would be blue.

tip

Conditional style tiles can be reordered by dragging and dropping, which will change the order in which their rules are applied.

Add a default style

In contrast to a conditional style, a default style is applied to all members of the selected measure unconditionally. However, it has the lowest priority and is overwritten by any conditional styles.

To add a default style:

• Hover the tile with the name Default in the Style editor, you will see some icons appear on the right of the tile.
• Click the edit icon, this will open a popup containing a color palette.
• Choose a color, then click Apply style.

Edit a conditional/default style

To edit a conditional or default style:

• Hover over the corresponding tile in the Style editor, you will see some icons appear on the right of the tile.
• Click the edit icon, this will open the Edit style popover.
• Make your changes, either to the rules or the colors, then click Apply style.

note

On table widgets, you can choose to apply conditional or default styles to entire rows (as opposed to individual cells) when the value of the cell in the column corresponding to the selected measure fulfills the condition(s). To do so, click the Apply to full row checkbox.

Remove a conditional/default style

To remove a conditional or default style:

• Hover over the corresponding tile in the Style editor, you will see some icons appear on the right of the tile.
• Click the X icon.

Reset fields

Clicking the Reset fields button will remove any default or conditional styles and number formatting that has been applied to a widget.

Table styles

The following section of the Style editor will only be visible if the selected widget is a table.

Table size

Table widgets can be made 3 different sizes: small, medium or large.

• To change the table size use the Table size dropdown to select the required size.

tip

The default table size can be configured via the table.defaultSize setting.

Headers wrap

Sometimes, the text content of a header cell (at the top of a table) is too long to fit. Headers wrap allows you to control what happens in this situation. When switched on, the text wraps and is displayed on several lines. When switched off, the overflowing part of the text is truncated and an ellipsis is shown. The full text can be seen in a tooltip, visible when hovering over the cell.

• To switch the table header text wrapping on or off, toggle the Headers wrap switch in the Style editor.

tip

The default table header text wrapping can be configured for all tables at once using the table.headers.wrap setting.

Table cell tooltips

Tooltips appear when hovering over table cells. They allow you to see at a glance which members a specific figure corresponds to, which is otherwise not always obvious in a large table.

• To switch table cell tooltips on or off, toggle the Tooltips switch in the Style editor.

note

This does not affect tooltips on cells with truncated texts, which remain always on.

tip

The default visibility of table tooltips can be configured for all tables at once using the table.tooltips setting.

Row numbers

Row numbers can be useful in order to identify specific rows in a large table. They also enable selecting a whole row by clicking on its number.

• To show or hide row numbers, toggle the Row numbers switch in the Style editor.

tip

The default visibility of row numbers for tables can be configured using the table.rowNumbers setting.

Chart styles

The following sections of the Style editor will only be visible if the selected widget is a chart.

Axis titles

Axis titles display the names of hierarchies and measures used in a chart, on the X and Y axes. For example, a simple line chart with City on the X axis and delta.SUM on Values in the Content editor would display the title City under the chart, parallel to the X axis, and delta.SUM on the left, parallel to the Y axis. If a chart contains more than one measure or hierarchy, these will all appear in the axis title as a list separated by commas.

• To add or remove axis titles, toggle the switch in the Style editor.

Axis labels

To change the font size of axis labels, change the value of Axis labels size in the Style editor.

Data labels

Data labels can be used to display values on a chart. For line charts, the data labels will appear next to each chart point, for bar and columns charts they will appear inside the bar or column, and for pie or donut charts they will appear inside each sector. To change the format or number of decimal places shown in the data labels, see format values.

• To add or remove data labels, toggle the switch in the Style editor.

Colors

The Colors section of the Style editor enables you to change the colors of a chart. Where this color is applied will depend on the chart type.

Chart type	Applied per	Applied to
Line chart	Measure	Chart trace and area
Column chart	Measure	Columns
Bar chart	Measure	Bars
Pie/Donut chart	Member	Sectors
Scatter plot	Member	Markers

To change the chart colors:

• In the Colors section, you will see tiles for each measure (for line, column or bar charts) or each member (for pie/donut charts or scatter plots).
• Hover over the tile for the measure/member for which you wish to change the color, you will see an edit icon appear on the right of the tile.
• Click the edit icon to open the Edit colors popover.
• Choose a color from the color palette, or choose a custom color by entering a hex color code in the input box.
• Click Apply color.

You can reset all colors back to their defaults by clicking the Reset colors button at the bottom right of the Colors section.

note

If there is a default or conditional style applied to the chart, this will override the chart colors for all chart types except line charts (because default/conditional styles affect the chart points whereas the color affects the chart trace and area).