Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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

@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

@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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors