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
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
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!