Insert data input rows

Quite often, we would need to insert a row in our table/matrix reports in Power BI and enter our own data. For example, a financial statement report connecting to a database query may be able to fetch revenue & expense metrics, but it might not retrieve the number of shares outstanding. Similarly, a sales report can leave out the sales data for a newly launched product category.

To address such scenarios, Premium Table allows you to insert static rows in where you can input or enter the data.

1. Insert data input row

You can insert data input rows from the Insert tab > Insert Row menu. Please bear in mind that the Insert Row button will be disabled until you select a row in your report. Select the Static Row option from the Data Input menu.

Inserting static rows from the data input menu

Another way to insert static rows is by using the row gripper. The gripper icon is highlighted when you hover over a row. Click on it, then select the Insert > Add Static Row option.

Inserting static rows from the row gripper

1.1. Data input row properties

A side panel opens when creating a data input row. Type in the name of the category in the Title textbox and click Create. You will see an empty record created above the row that was selected.

Data input row created

i. Scaling factor

You can set the scaling factor(Thousands, Millions, Billions, None, etc) for the static row depending on the data that is expected to be entered. It is set to Auto by default.

ii. Include in total

When the 'Include in total' option is enabled, any values we type in for the new row also contribute to the grand total row.

1.2. Delete a static row

To delete a static row, hover over the row and click on the row gripper. Select the 'Delete Row' option. You can also delete rows from the Manage Rows interface that will be covered in subsequent sections.

Deleting a static row