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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Spigaw
Helper III
Helper III

Replace same values in the advanced editor

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) :

Spigaw_1-1648537416614.png

Is there a way to replace all these values with date only and all at once, without doing it manually?

 

Thanks in advance.

 

1 ACCEPTED SOLUTION
Vijay_A_Verma
Most Valuable Professional
Most Valuable Professional

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.

View solution in original post

3 REPLIES 3
wdx223_Daniel
Community Champion
Community Champion

you can copy the code into txt file, or word, then find and replace, and copy back into the editor.

Vijay_A_Verma
Most Valuable Professional
Most Valuable Professional

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.

I really wish that Microsoft would put effort into some of these base case scenarios. This is not rocket science, but it is very helpful if find-replace could be supported. 

Even just a simple "find" capability would be great. The suggestion to hold down the Alt key is not good enough. 

The only way to do this is to copy to another editor, such as NotePad++

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.