Forum Discussion
Create a Dynamic Column in a Table Visual
I am trying to create a table visual with a dynamic column that lets the user change the value in that column for each row. For example, the table columns are vendor, settle amount, days to pay, proposed days to pay, and PNL benefit. Right now, the proposed days-to-pay column can be changed for all rows using a slicer. However, they would like to be able to change that value in the column for each row. The last column is a measure that determines the PNL benefits based on the settlement amount, current days to pay, and proposed days to pay. Is there any way to edit that column in near real time for each vendor row?
Anonymous
No, this is not possible in Power BI table visuals.
Power BI visuals are read-only. Users cannot directly edit values per row in a table and have measures recalculate in real time.
Why this doesn’t work in Power BI:
Table visuals do not support per-row user input.
Slicers apply the same value to all rows in the current filter context.
Measures recalculate only from model data or slicer/filter context, not manual edits.
Power BI has no concept of “write-back” or editable cells.
What is possible (workarounds):
Option 1: Disconnected parameter table (limited)
You can let users select a value via slicer or parameter
But it applies globally or by filter, not per row
Option 2: “What-if” parameters per scenario
Create multiple scenario columns (Scenario A, B, C)
User switches scenarios, not individual rows
Option 3: Use Power Apps (best workaround)
Embed a Power Apps visual
Allow users to edit Proposed Days to Pay per vendor
Write values back to a data source (SharePoint, Dataverse, SQL)
Refresh or DirectQuery updates PNL measure
9 Replies
Anonymous
No, this is not possible in Power BI table visuals.
Power BI visuals are read-only. Users cannot directly edit values per row in a table and have measures recalculate in real time.
Why this doesn’t work in Power BI:
Table visuals do not support per-row user input.
Slicers apply the same value to all rows in the current filter context.
Measures recalculate only from model data or slicer/filter context, not manual edits.
Power BI has no concept of “write-back” or editable cells.
What is possible (workarounds):
Option 1: Disconnected parameter table (limited)
You can let users select a value via slicer or parameter
But it applies globally or by filter, not per row
Option 2: “What-if” parameters per scenario
Create multiple scenario columns (Scenario A, B, C)
User switches scenarios, not individual rows
Option 3: Use Power Apps (best workaround)
Embed a Power Apps visual
Allow users to edit Proposed Days to Pay per vendor
Write values back to a data source (SharePoint, Dataverse, SQL)
Refresh or DirectQuery updates PNL measure
To do that in each row isn't possible with the table visual. What you describes sounds like maybe the need for more slicers or a field parameter to filter the table in different ways to get the results they want. If they are looking for a table of rows that each have different filters, I'm not sure how you would do that just because of how Power BI works.
You may be able to create a calculated column based on the vendor specific logic they are seemingly needing. That way your measure would be able to do the vendor specific calc instead of changing the cells on the table.
Hi Anonymous If you really wants to do the writeback feature you can take help from Power Apps or Fabric User Defined Functions (UDF).
Thanks
Hi Anonymous
What you're trying to achieve is data writeback which Power BI doesn't natively support. There are third party vendors, if budget is not an issue, that provide such a feature (https://marketplace.microsoft.com/en-us/marketplace/consulting-services/pomerolpartnersltd.peraison_poweron). Other options are:
- Fabric Translytical Task Flows
- PowerApps
Hi Anonymous ,
Thank you for reaching out to the Microsoft Community Forum.
Hi Amar_Kumar , Royel , d_m_LNK and danextian Thank you for your prompt responses.
Hi Anonymous , could you please try the proposed solutions shared by Royel , d_m_LNK and danextian ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
Hi Anonymous ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
