cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User II
Super User II

Unexpected long numbers round in Table visual

Hi 

thanks for @lawsonbe I can confirm an issue from here https://community.powerbi.com/t5/Desktop/Long-ID-number-rounding/m-p/1082309#M501152

I experience the same problem, built-in table visual round long numbers

Снимок.PNG

 

but

Снимок.PNG

ID Data type is Number. Solution is to change date type to Text in Power QUery, but it doesn't reject a problem with Visual

 


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
1 ACCEPTED SOLUTION
Community Support
Community Support

@az38 ,

 

I have found existed ticket so this is a known issue. And PG's anwser is by design because numbers use floating point, so certain values can't be represented with full precision.

 

As workaround, you can convert data from whole number type to text type.

 

Regards.

Jimmy Tao

View solution in original post

1 REPLY 1
Community Support
Community Support

@az38 ,

 

I have found existed ticket so this is a known issue. And PG's anwser is by design because numbers use floating point, so certain values can't be represented with full precision.

 

As workaround, you can convert data from whole number type to text type.

 

Regards.

Jimmy Tao

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors