Create a Dynamic Column in a Table Visual

[joshuac055]

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? 

[Amar_Kumar · Accepted solution]

@joshuac055 

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:

1. Table visuals do not support per-row user input.

2. Slicers apply the same value to all rows in the current filter context.

3. Measures recalculate only from model data or slicer/filter context, not manual edits.

4. 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

[v-dineshya]

Hi @joshuac055 ,

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 @joshuac055 , 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

[v-dineshya]

Hi @joshuac055 ,

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

[danextian]

Hi @joshuac055 

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_...). Other options are:

• Fabric Translytical Task Flows
• PowerApps

[Royel]

Hi @joshuac055 If you really wants to do the writeback feature you can take help from Power Apps or Fabric User Defined Functions (UDF). 

Thanks 

[d_m_LNK]

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.

[Amar_Kumar · Accepted solution]

@joshuac055 

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:

1. Table visuals do not support per-row user input.

2. Slicers apply the same value to all rows in the current filter context.

3. Measures recalculate only from model data or slicer/filter context, not manual edits.

4. 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

[joshuac055]

For option 3, do you have any resources that I could look into about creating that Power App visual?

[Royel · Accepted solution]

You can start from here 

1. https://www.youtube.com/playlist?list=PLTyFh-qDKAiFUEgsXoQ9E-LJu4lcS0iMI 

2. https://learn.microsoft.com/en-us/training/paths/power-apps-online-workshop/ 

[joshuac055]

Thanks!