Phone Number Formatting

[PCorbitt]

Hello Forum Team!

How do I get the 12 digit formats in my Power BI table to be formatted using the country code? Example: #52 (123) 456-7890? If I have another country that uses a 3-digit country code. How do I override the custom format I just made? Currently the colums are saved as text. Thank  you!

[Anonymous]

Thank you @vicky_  for your prompt reply.

Hi @PCorbitt ,
May I ask if you have tried the suggestions above? If the suggestion helped you, you might consider marking it as a solution. If the problem has not yet been solved, please feel free to ask us a question.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicky_ · Accepted solution]

This article goes through how to format numbers using different currency symbols, and you should be able to easily adapt it to suit your phone number formatting scenario: https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/