cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Spigaw
Helper II
Helper II

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
Super User
Super User

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

2 REPLIES 2
wdx223_Daniel
Super User
Super User

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

Vijay_A_Verma
Super User
Super User

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.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors