Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am wanting to show my percentage with two decimal places WITHOUT rounding to two decimal places!
Example:
This is it when I set it to 3 decimals:
This is it when I have it set to 2 decimals:
I want it to show:
2770-03 $3,271,000 $3,270,959.15 99.99%
I am showing accuracy of the estimation and the 100.00% gives false information that the estimation was exactly the same as the actual.
Solved! Go to Solution.
Hi @ACraig08 ,
Thanks for your question and have a nice day.
This is the source data:
I reproduced your error:
To resolve this error, implement your needs as follows:
1. Create a new column. The syntax format of the new column is as follows:
Column = ROUNDDOWN([D],4)
2. Select Format as Percentage and choose to keep two decimal places. At this time, keeping two decimal places will not round to 100.00%, but 99.99%.
Your needs have been implemented so far. If you want to know more about ROUNDDOWN(), please refer to the following documents:
ROUNDDOWN function (DAX) - DAX | Microsoft Learn
If you have any questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi @ACraig08 ,
Thanks for your question and have a nice day.
This is the source data:
I reproduced your error:
To resolve this error, implement your needs as follows:
1. Create a new column. The syntax format of the new column is as follows:
Column = ROUNDDOWN([D],4)
2. Select Format as Percentage and choose to keep two decimal places. At this time, keeping two decimal places will not round to 100.00%, but 99.99%.
Your needs have been implemented so far. If you want to know more about ROUNDDOWN(), please refer to the following documents:
ROUNDDOWN function (DAX) - DAX | Microsoft Learn
If you have any questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
This was very helpful, thank you!
Just in case others see this I also found a way to do it in Power Query part using the Transform tab! I had created the percent columns that way so it worked better for me!
choose the measure the caluclates the %, then choose the number of decimals you want to display.
and in the Dax code, use round( [measure] , 0 )
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that thumbs up button 🫡👍
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |