Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
ACraig08
Helper I
Helper I

Show 2 decimals with percentage NOT round to 2 decimals.

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:

ACraig08_0-1706041578496.png

This is it when I have it set to 2 decimals:

ACraig08_1-1706041641104.png

 

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.

1 ACCEPTED SOLUTION
v-huijiey-msft
Community Support
Community Support

Hi @ACraig08 ,

 

Thanks for your question and have a nice day.

 

This is the source data:

vhuijieymsft_0-1706060356552.png

 

I reproduced your error:

vhuijieymsft_1-1706060363856.png

 

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)

 

vhuijieymsft_2-1706060371004.png

 

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%.

vhuijieymsft_3-1706060378837.png

 

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!

View solution in original post

3 REPLIES 3
v-huijiey-msft
Community Support
Community Support

Hi @ACraig08 ,

 

Thanks for your question and have a nice day.

 

This is the source data:

vhuijieymsft_0-1706060356552.png

 

I reproduced your error:

vhuijieymsft_1-1706060363856.png

 

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)

 

vhuijieymsft_2-1706060371004.png

 

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%.

vhuijieymsft_3-1706060378837.png

 

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!

ACraig08_0-1706187817669.png

 

Daniel29195
Super User
Super User

@ACraig08 

 

 

choose the measure the caluclates the %,  then choose the number of decimals you want to display.

Daniel29195_1-1706042600283.png

 

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.