Power BI rounding up numbers even if format selected as decimal with 7 decimal places.

[PrashantN]

I have created 2 measures.
1. Amt - Basis some formula.
2. Amt in Cr - Amt/10000000

While pulling these measures in a table visual, i could see Amt in Cr measure value is getting rounded up even if i have selected format of Amt in Cr measure to Decimal with 7 digits.

E.g. 4,449.88 value is being displayed as 0.0004000 as shown below. However i wanted result to look like 0.0004449. 

Please help me on how i can show numbers till 7 decimal places without rounding up. 

Thanks in Advance.

[mangaus1111 · Accepted solution]

Click on the header of the column and then it appears

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PrashantN]

Hi @mangaus1111 ,

Amt and Amt in Cr are not columns. They are measures. 

[mangaus1111]

Check all the data types of all the columns of your imported table.

[mangaus1111]

Hi @PrashantN ,

I guess that you have values in your imported table as well. Check that the value in your imported table has "decimal number" as data type (and not "fixed decimal number")

[PrashantN]

Hi @mangaus1111 - Thanks for your help. I changed the data type of the underlying column of these measures as per your suggestion and it is working now as expected.  

Really Appreciate quick revert. Thanks once again.

[mangaus1111]

Hi @PrashantN ,

please make sure that you have decimal number data type here

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PrashantN]

Hi @mangaus1111 ,

I tried checking that option in my Power BI Desktop but its not there. I am using latest power bi desktop version. Here is the snapshot for your reference,

Please let me know if there is any other way?