How to get 0's to pull in PowerBI

[Anonymous]

Hello,

I have a dataset that supplies information to multiple reports. Some of the reports require phone numbers in one format, some require phone numbers in another. The SQL data has phone numbers stored in the format of 5555555555 to allow for easier formatting going forward. However, if a number hasn't been given, the default number it should display is 0000000000. This is the case when certain reports allow for the number to pull in the default format, but in other reports where the phone format has to be something like 000-000-0000 the phone numbers will just read as -- because PowerBI is storing the number as an integer (i.e., as just 0). Is there a way to get 0's to pull as  astring rather than an integer? 

Thanks in advance!

(Please note: I do not have access to Power Query with this dataset. The organization does not grant me access to this feature, everything I do has to be through DAX). 

[Fowmy]

@Anonymous 

Can you provide some sample data and show the expected results?

[Anonymous]

Hello,

I hope this screenshot is clear, the "Stored" column is how the phone number is being stored on the SQL server, the "Pulling As" is how it is appearing in PowerBI, and the "Desired Result" is what I want the number to read as after formatting the column to pull with dashes in it. 

[V-lianl-msft]

Hi @Anonymous ,

You can try to customize the formatting of this column in the model view:

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

[Anonymous · Accepted solution]

Hello Liang,

Unfortunately this data is formatted into text, so I was unable to use the "Custom Format" option. I did end up figuring out how to get it to work though, I just had to add in a formatting specification in DAX for 000-000-0000. Thank you for your help though!