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.
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) Insert as
Data input columns can be inserted as a measure or a column.
Visual measure: If there is a column hierarchy, the input column is inserted for each category. In case of no column hierarchy, a single column is inserted.
In the below image, a text column has been inserted as a measure by selecting 'Insert as' -> 'Visual measure'.
Visual column: Irrespective of whether there is a column hierarchy or not, a single column gets inserted.
In the below image, a text column has been inserted as a column by selecting 'Insert as' -> 'Visual column'.
b) Allow input
By default, inputs are enabled in both read and edit modes in Power BI. But, based on your requirement, you can allow inputs only in edit mode or based on a formula.
a) 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.
3. Access control
Inforiver Writeback Matrix allows setting explicit read/write access on data input columns for specific users. To set user access control, open the Manage Columns menu and click on the user icon.
In the Data Input Access dialog box, you can assign access to users for each column or measure.
4. FAQs
1) Can multiple users enter data in a single published report?
Yes. When you use Inforiver Writeback Matrix, multiple users can enter data in the same form in the reading view. Using the audit module, you can also keep track of changes made to your table made by different users.
2. Will a user be able to see data entered by other users?
By default, yes. But if you enable row-level security, users will be able to see only the records they are authorized to see.
3. This is too good to be true. Is there something specific I should set up or configure so that my users can enter data?
Nothing. Just add the Inforiver Writeback Matrix visual to your report, and use the 'Data Input' feature to add fields of various types.
4. All of this is great. Can I write back this data to a database?
Yes. You can write back data to a destination database or shared drive storage. Inforiver supports destinations such as SQL, Snowflake, Azure, BigQuery, MySQL, Sharepoint, OneDrive and more. You may also simply export the data to a PDF or Excel file.
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
Allow multiple users to enter data in a blank table/form in Power BI
Last updated