Component Format Painter

Application Scenario

When creating a dashboard, you need to unify the component styles.

Utilizing the format painter tool, you can efficiently apply the style of one component to others to ensure stylistic consistency and enhance aesthetics. This approach can boost the efficiency of style adjustments significantly.

Function Description

Format painter usage specifications:

• Operation within a single dashboard: The format painter only supports copying and pasting the format within a single dashboard. The format painter does not support copying a format from components in the current dashboard and pasting the format to the components in other dashboards.

• Consistency of component types: The format painter can only be applied to the format of components of the same type. For example, copy the format of one table component and paste the format to another table component or apply the format of one KPI card to another by the format painter. Expand to view the introduction of component types.

• When the same style configuration items exist in the source chart and the target chart, the style of the former can be applied to the latter. The configuration range of the format painter includes table properties,     component styles, and value axis settings.

Download the sample data: Office Supplies Data.xlsx.

Apply the style of Regional Sales Performance to Product Sales Performance.

Data Preparation

Create an analysis subject, and upload the sample data, as shown in the following figure.

Creating a Component

1. Use Area, Sales, Profit, and Quantity to create a group table to display regional sales, as shown in the following figure.

2. Set the table style.

>Table Font: Align the indicators in the table body to the left.

Style: Select Style 2, and set the theme color to #b7d2b6.

3. Use Product Name, Sales, and Profit to create a group table to display the product sales, as shown in the following figure.

Copying the Style by the Format Painter

Click the Add Dashboard button, and drag the two components you created to the dashboard, as shown in the following figure.

Click the component, select Format Painter to copy the current component style, and then select the component to which you want to apply the component style, as shown in the following figure.

Only Suitable for KPI Cards with the Same Number of Columns

The format painter can only be used to copy and paste styles when the number of columns in each row of the KPI cards is the same.

Assume that you have three KPI components with the column configurations as follows:

• Component 1: The splitting method is 2:1.

• Component 2: The splitting method is 2:1.

• Component 3: The splitting method is 1:2.

Copy the style of component 1 by the format painter. The style of component 1 can be applied to component 2, but not to component 3.

Unable to Copy and Paste the Condition Style of the Field Style by the Format Painter

You cannot copy and paste the field style that has been set with condition style by the format painter.

If the color of a field is dynamically set based on specific conditions (for example, the value of the field), you cannot copy this style and paste it to other components by the format painter.

Example 1: Add conditions to shape styles. When the region is Northwest, a circle is displayed in the row where the Area Northwest is located. This style setting cannot be copied and pasted to other components by the format painter.

Example 2: Customize the graphic properties to different colors based on different sales ranges. This color style cannot be copied and pasted to other components by the format painter.

Rules for Transferring Properties and Styles

Transferring Properties and Styles by Order

When you copy and paste the format style of a multi-dimensional and multi-indicator component by the format painter, the chart properties of the fields of the source component will be applied to the fields of the target component according to the order of the fields of the source component. When the fields of the source component are used up, the transferring process will restart from the first field and continue until all fields of the target component are applied with the format.

Transferring Styles Between Components with the Same Attribute Configuration

To copy properties and styles from one component and paste the styles to the other component by the format painter, the two components must be set with the same configurations of the corresponding attributes.

If the dimension fields are configured in the color property in two components, the style can be transferred by the format painter. If no fields are configured in one of the components, or if one of the components is configured with a different type of field (such as an indicator field), you cannot apply the style to the other component by the format painter.

Customizing the Transfer Rules of the Chart Style

Rules for customizing the format painter of the chart: Match the same type of graphics.

If the source component contains graphics of a specific type, you can apply the styles of these graphics to the same type of graphics in the target component by the format painter.

If no charts of the same type in the target component match the charts of the source component, you cannot apply any chart styles to the target component by the format painter.