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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.