Customizing axis labels

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

You can create custom axis labels or titles for the bottom, left, and right axis of a chart and select which titles should be shown on the chart. By default, the name of the measure or dimension is used. If you remove a custom axis title, the value reverts to the default setting.

From Kyvos 2024.12 onwards, you can plot measures on the X-Axis of XY charts, provided that no dimensions are placed on the X-Axis. To enable this feature, a 'Plot Measures on X-Axis' checkbox will be added under Axis Properties. This option will only be available when there are no dimensions assigned to the X-Axis. When the 'Plot Measures on X-Axis' option is selected, the measure-level properties for all measures placed on the Y-Axis shelf will be synchronized. Therefore, any changes made to the properties of one measure will automatically apply to all other measures on the Y-Axis shelf.

• To render measures on the X-Axis of XY charts

• To show axis titles

To render measures on the X-Axis of XY charts, perform the following steps.

1. From the Toolbox, select Workbooks, then select a workbook.

2. Select a semantic model and create Worksheet

3. If needed, select Design.

4. Add measure in Y-Axis. There must be no dimension dropped on X-Axis.

5. Change the View Type to XY chart (Area, Bar, column, crosstab, curve, Plot, or Line)

6. In the Properties section, select the Plot Measures on X-Axis checkbox.

   Open

   

7. The measure will display in the X-Axis.

To show axis titles, perform the following steps: 

1. From the Toolbox, select Workbooks, then select a workbook.

2. If needed, select Design.

3. Click the arrow at the top of the Properties pane to switch between Worksheet properties and properties for the type of chart you view, for example, Bar.

4. Click the checkboxes below Show Value Axis to select which labels should be displayed. 
   Not all values apply to each chart type.

   Open

   

Creating axis titles

To create axis titles, perform the following steps: 

1. From the Toolbox, select Workbooks, then select a workbook.

2. If needed, select Design.

3. Click the arrow at the top of the Properties pane to switch between Worksheet properties and properties for the type of chart you view, for example, Bar.

4. Click the checkboxes to select which values to show: Bottom, Left, or Right.

5. For each axis, enter a title to replace the default name. 

Wrapping and truncating axis labels 

You can wrap or truncate the axis labels as needed. The chart can be exported in PDF format with wrapped axis labels. The axis labels can be wrapped both in the data card and on the dashboard.

To wrap or truncate the axis labels, perform the following steps. 

1. From the Toolbox, select Workbooks, then select a workbook.

2. If needed, select Design.

3. Click the arrow at the top of the Properties pane to switch between Worksheet properties and properties for the type of chart you are viewing, for example, Bar.

4. In the Axis Properties section, select the 0 angle from the X-Axis Label Angle list. The options Wrap and Truncate options displayed in the X-Axis Label Text list are enabled. 

5. If you select a specific angle from the X-Axis Label Angle list, such as 30, 45, 60, or 90, the axis labels will be truncated and inclined according to the selected angle. Additionally, the Truncate option is selected by default.

6. To wrap the axis labels without overlapping, select the 0-degree angle.