Forum Discussion
Force decimal instead of integer
- 9 years ago
Store Coverage = 10/3 should be a decimal number already.
In your screenshot, underneath "Decimal Number", Decimal Places is set to zero. Increasing that should increase the number of decimal places displayed for that measure.
In general, when calculating INTEGER / INTEGER, Power BI should convert both numerator and denominator to REAL before performing the calculation (according to this page).
Store Coverage = 10/3 should be a decimal number already.
In your screenshot, underneath "Decimal Number", Decimal Places is set to zero. Increasing that should increase the number of decimal places displayed for that measure.
In general, when calculating INTEGER / INTEGER, Power BI should convert both numerator and denominator to REAL before performing the calculation (according to this page).
Hi,
The option to increase decimal number for POWER BI Desktop isn't available.
Any other tips of how to increase decimal numbers?
I need numbers to appear as 3 decimal. Example: 0,121
- Greg_Deckler9 years agoCommunity Champion
In the data model, is the Data Type "Decimal Number"? Also, is the Format set to "Decimal Number"?
- marittmatias9 years agoNew Member
Hi,
There is no option to add decimal... I need 3 but appears only two.
Know when you pass the mouse in the chart and the values appears? In this box, always appears with only 2 decimal, and I need 3...
I'm trying to add my print screen here but it's not possible...
Thank you!
- Greg_Deckler9 years agoCommunity Champion
You mean this is not possible?