Insert data input columns

Inforiver Premium Table provides five different options to manually enter data in your Power BI table report, which are listed below. Data can be entered in a single cell or several cells at the same time, and they can be formatted in a variety of ways. Also, there are several settings that you can adjust to make data entry easier for you.

Input type
Description

Double-click and start typing values in directly into a cell

Enter text with multi-line support and word wrap

Use the available presets or create your own list of values; supports both single-select and multi-select

Add a date from the calendar/date picker

Used in case of binary selections

Inserting Data Input Columns

You can now start inserting a column to capture your data inputs by clicking on Insert --> Data Input.

Before we look at inserting data input columns, let's look at some common properties available for all the input types.

2. Common properties

a) Allow input

By default, inputs are enabled in both read and edit modes in Power BI. But, depending on your requirement, you can allow inputs only in edit mode or based on a formula.

b) Only in edit mode:

When the 'Only in edit mode' option is chosen, the text editor is disabled.

b) In both Power BI read and edit modes:

When the option 'In both Power BI read and edit modes' is selected, you can enter data in the reading view as shown below.

c) Based on a formula:

You can allow data input only if a certain condition is met. The formula entered should return a boolean.

In the below image, data input is allowed only if (2022 Actuals - 2022 Plan)% < 0. You can see that the text fields for Central and Midwest are greyed out.

In the next section, we'll be looking at inserting number columns.

Resources

5 types of manual data entry options in your Power BI table/matrix

Input & Edit Sales Forecasts in a Power BI Report

Last updated