Hi @achristopherson,
Two approaches could format the phone number.
Assuming that your Phonen umber is "111222333", you want to have the format of "111-222-3333". You could refer to the ways below.
1. In Power Query, split that one column into 3 and add a new custom column.
Note: you need to change the Phonenumber.1,Phonenumber.2 and Phonenumber.2.2 to text type, then add the custom column.
2. With Dax expression, change that column1 to decimal type and use FORMAT(TABLE[PHONENO],"###-###-####")
Hope it can help you!
Best regards,
Cherry
Hi @achristopherson,
Two approaches could format the phone number.
Assuming that your Phonen umber is "111222333", you want to have the format of "111-222-3333". You could refer to the ways below.
1. In Power Query, split that one column into 3 and add a new custom column.
Note: you need to change the Phonenumber.1,Phonenumber.2 and Phonenumber.2.2 to text type, then add the custom column.
2. With Dax expression, change that column1 to decimal type and use FORMAT(TABLE[PHONENO],"###-###-####")
Hope it can help you!
Best regards,
Cherry
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
