Data Bar Setting

Version

Application Scenario

You want to compare data in a table.

Function Description

The data bar can visualize data, making it easier to directly observe data, as shown in the following figure.

Applied Scope

The data bar setting is supported in the group table and cross table, but not in the detail table.

Data Preparation

1. Log in to FineBI, click My Analysis, select a folder, and click New Subject.

2. Click Local Excel and Upload Data.

You can download the sample data: Contract Information.xlsx

3. Click OK after the data is uploaded.

4. Click Save and Update and Exit and Preview. The data is created successfully.

Component Creation

1. Click the Component tab in the lower left corner.

2. Select Group Table in Chart Type.

3. Drag the Contract Signing Date field from the to-be-analyzed area into Dimension, and the Contract Amount field into Indicator, as shown in the following figure.

Opening Data Bar

Click the  button next to the Contract Amount field in Indicator and select Open Data Bar from the drop-down list, as shown in the following figure.

Setting Data Bar

The explanation of the system default setting is shown as below.

1. Values existing in the table cells are positive only:

The length percentage of the data bar is 1 when cells contain the maximum value. By contrast, the length percentage of the data bar is 0 when cells contain the minimum value. Besides, the length percentage of the data bar corresponding to other values is calculated according to the formula: (x-min value)/(max value-min value).

2. Values existing in the table cells are negative only:

The length percentage of the data bar is 1 when cells contain the minimum value. By contrast, the length percentage of the data bar is 0 when cells contain the maximum value. Besides, the length percentage of the data bar corresponding to other values is calculated according to the formula: (x-min value)/(max value-min value).

3. Table cell values are mixed with positive values and negative values:

When the value in a cell is negative, the data bar within that cell extends to the left of the zero line and is displayed in red. By contrast, when the value in a cell is positive, the data bar within that cell extends to the right of the zero line and is displayed in green.

The zero line is calculated according to the formula: (0-min value)/(max value-min value). The range of the formula is [0,1], with values greater than 1 taken as 1 and values less than 0 taken as 0. (0 corresponds to the far left of a cell and 1 corresponds to the far right of a cell.)

The value position is calculated according to the formula: (x-min value)/(max value-min value). The range of the formula is [0,1], with values greater than 1 taken as 1 and values less than 0 taken as 0. (The length between the value position and the zero line is the length of the data bar.)

Note:

1. The Max Value and Min Value above are synchronized with those obtained from the latest results in the analysis area.

2. If you customize Max Value and Min Value, the customized values will be used in all the formulas above.

2. Click the  button next to the Contract Amount field in Indicator and select Data Bar Setting from the drop-down list to set the data bar.

1. Setting Max/Min Values

1. Set Min Value and Max Value to Custom. Enter 600,000 in the input field of Min Value and enter 100,000,000 in the input field of Max Value. (You need to set the maximum value first, otherwise "The maximum value cannot be less than the minimum value" will prompt.)

2. The following figure shows the effect.

2. Setting the Value Colors

1. Set Positive Color to purple. (The table in this example contains only positive values, so only Positive Color is set to purple.)

2. The following figure shows the effect.

3. Setting to Only Show the Data Bar

1. Check Only Show Data Bar, as shown in the following figure.

2. The numbers are hidden and only the data bar is displayed, as shown in the following figure.

The data bar setting takes effect only on the indicator corresponding to the innermost dimension rather than the summary row.

Null values are not included in the data bar calculation.

In the event of the following scenarios, despite the data bar function being enabled, cells that contain the indicator values do not display data bars.

1. The indicator values contain infinite ones, which are also included in the set Max Value and Min Value.

2. All indicator values are equal.

3. All indicator values are less than the minimum value set for the data bar.