Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
When I click on one element which appears many times in the advanced editor, all its occurrences get highlighted (for example below with datetime) :
Is there a way to replace all these values with date only and all at once, without doing it manually?
Thanks in advance.
Solved! Go to Solution.
Advanced editor doesn't offer Find and Replace All capability like notepad, word etc. You can do following (it has manual component though) -
Hold ALT key and select all occurances which you want to replace one by one while holding ALT key (It is not mandatory to hold ALT key when you first select the word, but for all other selections holding ALT key is mandatory).
Once done whatever you do for the first word, the same will be applicable for all other words.
So, if you have 4 occurances of word datetime, you will need to select all 4 occurances of word datetime one by one while pressing ALT key. If you change datetime to say text, all datetime occurances which you had selected will be converted to text.
you can copy the code into txt file, or word, then find and replace, and copy back into the editor.
Advanced editor doesn't offer Find and Replace All capability like notepad, word etc. You can do following (it has manual component though) -
Hold ALT key and select all occurances which you want to replace one by one while holding ALT key (It is not mandatory to hold ALT key when you first select the word, but for all other selections holding ALT key is mandatory).
Once done whatever you do for the first word, the same will be applicable for all other words.
So, if you have 4 occurances of word datetime, you will need to select all 4 occurances of word datetime one by one while pressing ALT key. If you change datetime to say text, all datetime occurances which you had selected will be converted to text.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.