How to format Phone Numbers?

[achristopherson]

What is the recommended way to format phone numbers? Power BI keeps trying to treat them as decimals or whole numbers. Currently, the numbers are in a string format with no spacing or hyphens. 

[v-piga-msft · Accepted solution]

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

[achristopherson]

Great, thank you for your help!