Issue with format of the text

[avinrosh]

I am importing a column with numers as text in power bi.

For example I will import 123456 as text and making sure in Power query is remains text, but when I close and apply I see the data in the table for some reason 123456 converts as 123456.0 and the type remains as text.

Whereas I want it to mainain its format and remain as 123456.

Kindly help.

Thanks 

Avinash

[Anonymous]

@avinrosh 

I can't reproduce your scene.

There are two ways to try:

The first:

1. Create calculated column.

Column 2 = LEFT('Sheet1'[column],6)

2. Result.

The second:

1. First convert it to Whole Number in Power query.

2. Convert it to Text in Power bi.

Best Regards,

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

[parry2k]

@avinrosh do you see data type is text and also format is set to text (which logically should be)

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡