Skip to main content

Power BI

Needs Votes

Edit a single cell in Power BI Desktop Query Editor

Vote (5) Share
Power BI User's profile image

Power BI User on 05 Mar 2020 18:46:13

While using Power BI Desktop Query Editor, it would be nice to have the ability to select a specific cell and update only its content. The Replace Values options is nice, but there are many times a specific single cell needs to be updated. Maybe add a Replace Value UI to perform this function. Thx

Comments (1)
Power BI User's profile image Profile Picture

Amy M on 23 Sep 2020 00:11:19

RE: Edit a single cell in Power BI Desktop Query Editor

Upvoting - this would be a very useful function. For example, once in awhile I need to manually edit data such as an invoice due to a billing error, so that it doesn't impact global reports. I can't just replace the value of say, a specific date or specific dollar amount because other invoices share those values. There should be a function where you can replace a value in a column but tie it to the primary key - to ensure that only the specific value gets altered.