Edit & Add Rows in Power BI

Empower users to add, delete, and update rows directly within their preferred analytics tool, eliminating the need for external tools like Excel.

WeWrite enables you to…

Modify Data

Planning built on your existing data drastically improves user experience and reduces the time and cost of implementing planning modules.

Add and Delete rows

Ensure accurate, up-to-date data by allowing users to add, delete, and modify records directly in Power BI, removing the need for external tools.

Use scripts

With comments, notes, additional classifications, etc. added right in your Power BI reports, collaboration and transparency increase across teams.

Close the Loop

Modify Data Directly in the Report

Edit data that is written back to your chosen database with ease. We support various data types, including

Numbers
Percentages
Text
Dates
Dropdowns
True/False

Simplify NumberS Management

Bulk Edit Numbers in the Matrix Visual

With our matrix visual, you can bulk edit multiple numbers within the hierarchy. When you modify a total field, the child positions automatically adjust, making number manipulation straightforward, especially for planning purposes.

Whether you prefer a top-down or bottom-up approach, you can easily distribute numbers among child positions using either weighted or equal methods.

Dynamic Number Adjustments

Create Effortless Calculations

You can perform calculations directly within our tool using operations like

Addition
Subtraction
Multiplication
Division
Percentage Adjustments

This feature allows you to easily adjust numbers on the fly without needing to complete the calculations in advance.

Control Your Data

Add and Delete Rows

WeWrite goes beyond reporting. Users can add and delete data directly within their Power BI reports.

This ensures your data is always up-to-date and gives you the flexibility to add new lines of data that may not yet exist in your source systems.

For example, you can include potential investment projects or ideas for Capex planning, opening up a space for suggestions that can later be reviewed and confirmed as part of your capital expenditure strategy.

Enhance Functionality

Use Scripts

Our visual features a developer’s toolbox that allows you to run pre, post, insert, and delete scripts using data from Power BI as parameters.

For instance, you can execute a stored procedure in the insert script that captures the user inserting the row as a “createdBy” field, enhancing the visual’s functionality.

Resources from our Community

Our WIKI page

Looking for setup help, feature description, or licensing info? Visit our Wiki for easy instructions and more!

Get Help

Have questions or need help with implementation? Book a complimentary consultation and let’s chat!

Start Managing Data with WeWrite!

Scroll to Top