Forum Discussion
Create a Dynamic Column in a Table Visual
- 7 months ago
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
- 7 months ago
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/
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
For option 3, do you have any resources that I could look into about creating that Power App visual?
- Royel7 months agoSuper User
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/
- Anonymous7 months agoNot applicable
Thanks!