Marking Data of the Entire Row in a Table

Version

Expected Effect

You want to mark the indicator values of the entire row in red in a table.

For example, the indicator values of the entire row are marked in red if the values in the Data field are greater than or equal to 3.

Implementation Method

You can mark values in the Data, Data Two, and Data Three fields in red if the values in the Data field are greater than or equal to 3.

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: Marker Judgment.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 button in the lower left corner.

2. Select Group Table in Chart Type.

3. Drag the Type field from the to-be-analyzed area into Dimension and Data One, Data Two, and Data Three into Indicator, as shown in the following figure.

Text Color Setting

1. Drag the Data field from the left to-be-analyzed area into Color under Table Property > Indicator > All.

2. Click Color and click the Add Condition button in the pop-up setting box.

3. Set all values in the Data, Data Two, and Data Three fields are displayed in red if the values in the Data fields are greater than or equal to 3, as shown in the following figure.

Note:

Data marked in red in the summary row will not be displayed if you unselect Total Summary Row under Component Style > Summary Row.

Dashboard Creation

1. Click the Add Dashboard button at the bottom of the analysis subject editing page.

2. Drag the component into the dashboard on the dashboard editing page.

3. Select Edit Title from the drop-down list, set Font Style to Custom, set the title to Marking Data of the Entire Row in a Table, and click OK.

Effect Display

PC

Mobile Terminal