Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Solved! Go to 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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
76 | |
67 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |