Display long number (+15 characters)

[xejx]

In my data i have invoice number, like 181220013692, however Power bi display this as 181220000000. 
I store the data as decimal which should be able to hold info of all the digits I've tried changing to using a custom format of ############.  How do I display the full invoicenumber?

[PijushRoy · Accepted solution]

Hi @xejx 

Is there any issue if you show as Text
In Power Query, please update the Change Type step and use as Text

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin