Forum Discussion
Phone Number Formatting
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!
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/
2 Replies
- vicky_Super User
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/
- AnonymousNot applicable
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.