Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have a text field in a table where I need to substitute phone numbers where applicable.
For example the text field could have:
Call me on 08588812885
Call me on 07525812845
I need assitance please call me
Sometimes a phone number will be in the text but not always and the phone number entered will always be different.
Is there a measure to use to replace the phone numbers with no text
Solved! Go to Solution.
Hello @ryanb11 ,
Yes, that's possible, you can split them using this function in the energy query
I hope this helps!
Oops, i'm sorry I didn't realize you posted a sample of data about the comments section.
I found this @MarcelBeug solution
Try this too:
I've attached the pbix sample.
You can go directly to Power Query to check it.
I hope this helps!
Dear @ryanb11 ,
if your column contain value such as "Call me on 21823283 its urgent !!!"
then
Do following steps ,
1) go to Transform data (after importing data )
2) Do split column non- digit to digit you will get something like this
3)Then agian select the second column and do " Digit to Non Digit:" as shown below, as second column which may contain some text as it is not fixed that always numbers will be on rightmost side .
4) Then select the first and rightmost column , and right click it will option merge and merge it.
then a tab will get open select " space " and give proper name
then you will get this "A FoolProof Solution" this means let data come in any sequence you must be able to handle without lifting pinky finger
Please give kudos to this post to motivate and if it helped , do accept as solution
Regards ,
Sujit
Add a column with formulan the Query Editor
= Text.Combine(List.RemoveItems(Text.ToList([ColumnName]),{"0".."9"}))
Or
Choose Transform and adjust the code in the formula bar as below
= Table.TransformColumns(PreviousStep,{{"TextWithDigits", each Text.Combine(List.RemoveItems(Text.ToList(_),{"0".."9"}))}})
the adjustment is the part starting with "each".
the solution works partially the only issue if there are other numbers not as a phone number.
these get replaced when they need to be kept
so user cases are:
call me on 0845812856
call me on 0845812856 asap
cal me urgently
last contacted in 2019
arw you able to incorporate this into your custom column formula? @Anonymous
the solution works partially the only issue if there are other numbers not as a phone number.
these get replaced when they need to be kept
so user cases are:
call me on 0845812856
call me on 0845812856 asap
cal me urgently
last contacted in 2019
arw you able to incorporate this into your custom column formula?
Oops, i'm sorry I didn't realize you posted a sample of data about the comments section.
I found this @MarcelBeug solution
Try this too:
I've attached the pbix sample.
You can go directly to Power Query to check it.
I hope this helps!
@ryanb11 , refer if remove number from text can help
https://community.powerbi.com/t5/Desktop/Removing-Numbers/td-p/146489
another way is data masking
Hello @ryanb11 ,
Yes, that's possible, you can split them using this function in the energy query
I hope this helps!
Dear @ryanb11 ,
Can you elaborate or explain properly with some excel sheet in which you can show what actually you want in power bi.
so that we could try to help
Regards ,
Thakur Sujit
i am trying to get rid of the phone numbers as they are personal information and want to exclude from the visuals
user id column | text comment column | measure result |
1 | Call me on 08588812885 as I have an issue I cannot fix | Call me on as I have an issue I cannot fix |
2 | I am not happy with the service Call me on 07525812845 as soon as possible | I am not happy with the service Call me on as soon as possible |
3 | good service | good service |
Just to confirm your question: you are trying to extract the phone number, correct?
i am trying to get rid of the phone numbers as they are personal information and want to exclude from the visuals
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.