Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
I have uploaded my dataset into Power BI and are using the Power Query editor to change cell values. This worked fine but when new data is entered into the dataset the values are not being replaced with my 'replace value' settings.
Any ideas on how to automate this? For example if I were replacing "blue" values to "red", any time a new line containing "blue" would automatically be replaced to "red".
Hope this is clear.
Many thanks,
Elliot
Solved! Go to Solution.
Hi @Anonymous,
Maybe you can try to parameterize the 'replace value' function string with a query parameter, then you can change the query parameter to achieve dynamic replace effects.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
Maybe you can try to parameterize the 'replace value' function string with a query parameter, then you can change the query parameter to achieve dynamic replace effects.
Regards,
Xiaoxin Sheng
If you've used the 'Replace Values' from the column header and everything else is equal, it will work. So something is different about the new data (e.g. case)
@Anonymous
As you said the Replacevalue is part of the Query transformation so any new data added should go through the replace value process, can you share the M code?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |