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