Formatting options are options that does not change how the chart data is computed but rather how it is displayed.
By default, DSS choose how to format numbers based on available data for both axes and measures/numerical dimensions.
In order to give you more control over how these values are formatted, several formatting options are available:
multiplier (thousands, millions, billions)
Number formatting can be applied to:
axes: the formatting is applied to the axis tick labels;
measures/numerical dimensions: the formatting is applied everywhere a value of this measure/dimension is displayed (eg in tooltips and in the legend).
Note: axes and measures/dimensions are independent, meaning that if you want consistency between the axes tick labels and the measure/dimension values you have to apply the same options to the axes and the measures/dimensions from their dedicated configuration menus.
The “Display label” option allows you to change how the field name displays in the chart
Editing the “Display label” field will affect how that label is displayed in the chart: - for measures: tooltips and color label will be updated; - for dimensions: tooltips will be updated.
This option is available for most charts as soon as the measure/dimension name is displayed.
The “Display value in chart” and “Display labels in chart” options allow you to have the values and/or labels shown directly in the chart. These options are checkboxes that are placed on the left side of the chart, in the “Values” section.
The “Display value in chart” option is available on the following charts: - Vertical bars - Vertical stacked bars - Vertical stacked bars 100% - Horizontal stacked bars - Horizonal stacked bars 100% - Pie - Donut - Treemap
Note: on the treemap chart, this option is present both in the “Values” section (concerns the column used as “Value”), and in each dimension’s contextual menu (concerns the columns used as “Group”).
The “Display labels in chart” option is available for Pie and Donut charts.
Additionally, the values and labels displayed in chart can be customised. For all of the charts mentioned above, you can choose a font color, font size, add a background and change its color and opacity. The exception is the treemap chart, where you can only customise the font size. Additionally, for all bar charts, both vertical and horizontal, you can select an overlapping strategy, specifically whether to hide overlapping values or display all of them.
The axis formatting options concern axis ticks and titles. They allow you to change the font size and font color of axis ticks and titles (if shown in the chart) These customisation options are applicable for all the charts that have axes, excluding the lift and boxplot charts. They can be found in the axes’ contextual menus.
The legend formatting options are available for all the charts that have legends. They allow you to change the font size and font color of the items in the legend.