- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous ,
"Replace value" couldn't meet your requirement. As a workaround, you can add a custom column using power query code below:
Regards,
Jimmy Tao
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous ,
"Replace value" couldn't meet your requirement. As a workaround, you can add a custom column using power query code below:
Regards,
Jimmy Tao
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
07-14-2024 07:22 AM | |||
05-22-2024 11:25 PM | |||
11-15-2023 02:02 AM | |||
12-18-2023 10:48 PM | |||
12-04-2019 01:29 AM |
User | Count |
---|---|
100 | |
69 | |
42 | |
37 | |
30 |
User | Count |
---|---|
157 | |
89 | |
62 | |
46 | |
40 |