Row Height

1) Conditional formatting can control row height, so you can hide data by conditional formatting.

2) Prerequisites: Insert Data Columns, An Introduction of Conditional Formatting.

1. Create a new dataset [ds1]

1) Create a new DB query dataset.

2) Drag the table [Product] into the DB query.

2. Drag data columns into cells

1) B3~E3: Drag data columns [Product_name], [SupplierID], [Inventory_quantity] and [Order_quantity] into cells.

2) B2~E2: Input the header and fill them with grey.

3) B2~E3: Set as central alignment and add borders.

4) Preview.

3. Select D3 and add condition

4. Setting of property

1) Click + to select the property: Row Height.

2) Row Height: 0MM.

5. Add common condition

1) Operator: greater than or equal to.

2) Value Type: Integer.

3) Comparison Value: 10.

4) Click+ to add the common condition.

6. Preview 

Only the number of inventory less than 10 is displayed and others are hidden.

7. Add formula condition

1) Type: Formula. Click Edit.

2) Define the formula as D3 >= E3. Click OK. (Data columns [Inventory_quantity] and [Order_quantity] are inserted into D3 and E3 respectively)

3) Select the logical operator: AND.

4) Click + to add the formula condition.

8. Preview

Only the number of inventory less than 10 or less than the order quantity is displayed and others are hidden.