Forum Discussion

thavidu's avatar
thavidu
New Member
9 years ago
Solved

Force decimal instead of integer

I've been both trying and searching for hours, but I can't seem to figure out how to make my measure return a decimal number instead of an integer. In both Card and Table views, its only returning wh...
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    thavidu

     

    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).

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

In the data model, is the Data Type "Decimal Number"? Also, is the Format set to "Decimal Number"?

marittmatias's avatar
marittmatias
New Member
9 years ago

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_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    You mean this is not possible?