Displaying Images in a Table

Version

Application Scenario

You may want to display product images (stored in a URL format) in a FineBI table to facilitate identifying products and tracking sales data, as shown in the following figure.

Function Description

FineBI provides a function to display the text field data (URLs of images) in a table as images.

Note:

Only the text field data can be displayed as images.

Usage Scope

Group table, cross table, and 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: Product Sales.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, as shown in the following figure.

2. Click Group Table in Chart Type.

3. Drag the Name field in the to-be-analyzed area into Dimension and Sales into Indicator. (The content in the Name field is a URL of the image.)

Displaying Table Content as the Image

Click the  button next to the Name field in Dimension and choose Display Type > Display as Image, as shown in the following figure.

Dashboard Creation

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

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

3. Click the  icon and select Edit Title from the drop-down list, set Font Style to Custom, set the title to Displaying Images in a Table, and click OK.

Effect Display

On PC

Meanwhile, you can click the image in the table and click the  button in the upper-right corner to zoom in the image for viewing, as shown in the following figure.

On Mobile Terminals

If you set the text field data to be displayed as images, settings such as Customize Grouping, Color under Table Property > Dimension, and Table Font in Component Style will not take effect, unless you switch Display as Image to Display as Text.

If you set the text field data to be displayed as images, functions such as Linkage, Jump, Drill, Sort, and Filter will still take effect according to the field content. However, Linkage and Jump can only be triggered by clicking the non-image area, and if there is no such area, the two functions cannot be triggered.

Display as Image does not take effect when you export the table component as an Excel file.