How can I prevent rounding off ?

[Anonymous]

Hi Community!! I have a data connected to postgress through which I am preparing a report. Now There is one value which is currency having 19 digits before decimal points and 3 digits after decimal points. But when I am fetching that number from database I am getting vakue which is rounding off. I have attached screenshots as well.

Happy to share more info iff required.I have tried many options like to change format and all.

Kindly help!!This is orignal value in databaseThis is rounded off value in powerbi

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can change the data type in power bi desktop.

In power bi desktop, select the field then go in to column tools to change the number of decimal places. Make sure Date type and format are both decimal number.

Reference: Data types in Power BI Desktop

Best Regards,

Stephen Tao

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

[Pragati11]

Hi @Anonymous ,

In Power BI, click on your column Estimate Sales Value of Marketing. On th top ribbon, you will see all the data formatting options for this column along with the number of decimal places. Check how many decimal places are set there and modify accordingly.

Thanks,

Pragati