Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

How to change or replace a value of single cell in Power BI desktop

Hello All,

 

I am working on Excel datasource in Power BI where a single cell value need to be changed. I would like to explain with example of my excel datasource

 

In Dim_Section table I have columns - SectionCode and Modality

SectionCode          Modality

000                        Online

923                        Online

997                        In-class

850                        In-class

825                        In-class

 

In this table, i need to change the modality value of 000 sectioncode. The value online need to be changed to In-Class.

If i use the replace-value feature of power-bi the Online text for 000 and 923 section code both gets changed. I dont want to change the value for 923 section code

 

Is there any way to replace or change single cell value in Power BI

 

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

Syndicated - Outbound

@Anonymous ,

 

"Replace value" couldn't meet your requirement. As a workaround, you can add a custom column using power query code below:

Capture.PNG 

 

Regards,

Jimmy Tao

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

Syndicated - Outbound

@Anonymous ,

 

"Replace value" couldn't meet your requirement. As a workaround, you can add a custom column using power query code below:

Capture.PNG 

 

Regards,

Jimmy Tao

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)