Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Great, thank you for your help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |