Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lastnn30
Post Patron
Post Patron

decimal numbers are not showing in Power BI

Hi

I have decimal numbers in excel but Power BI is not showing decimal. I went to Power Query editor and made sure the column is decimal. Power query is showing decimal number but not power BI. Please see attached screenshots. Thank you very much.

 

SNAG-0622.jpg

SNAG-0623.jpg

2 ACCEPTED SOLUTIONS
Ashish_Mathur
Super User
Super User

Hi,

Write a measure as Sal = sum(Data[Salary]) and format the measure as Decimal number.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

PhilipTreacy
Super User
Super User

Hi @lastnn30 

 

Check the number of decimal places being used to display the Salary column.  If it's set to 0 then the numbers will be rounded i.e. Mya's salary will be displayed as 2 rather than 1.5

salary1.png

salary2.png

Regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

3 REPLIES 3
lastnn30
Post Patron
Post Patron

Thank you all for the help, really appreciate it. I got both solutions. thanks again.

PhilipTreacy
Super User
Super User

Hi @lastnn30 

 

Check the number of decimal places being used to display the Salary column.  If it's set to 0 then the numbers will be rounded i.e. Mya's salary will be displayed as 2 rather than 1.5

salary1.png

salary2.png

Regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Ashish_Mathur
Super User
Super User

Hi,

Write a measure as Sal = sum(Data[Salary]) and format the measure as Decimal number.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.