Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi,
Write a measure as Sal = sum(Data[Salary]) and format the measure as Decimal number.
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
Regards
Phil
Proud to be a Super User!
Thank you all for the help, really appreciate it. I got both solutions. thanks again.
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
Regards
Phil
Proud to be a Super User!
Hi,
Write a measure as Sal = sum(Data[Salary]) and format the measure as Decimal number.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |