Show 2 decimals with percentage NOT round to 2 decimals.

[ACraig08]

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.

[v-huijiey-msft · Accepted 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!

[ACraig08]

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!

[Daniel29195]

@ACraig08 

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 🫡👍