Forum Discussion

xejx's avatar
xejx
New Member
2 years ago
Solved

Display long number (+15 characters)

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 changi...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

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