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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
P_Kiranmai123
Frequent Visitor

Decimal values on Auto not showing 2 decimal places as default

Hi,
Greetings,
Could someone help me on this silly problem:
Matrix visual is showing values as calculator calculations such as 9.77777777instead of 9.78 or 9.77.( few decimal places )
If i change decimal places on power bi desktop modeling , decimal values are also applies to other single digit values.

Basically i need values as below:

0  as  0
5.2  as  5.2
9.55555   as 9.56

Please check the below screenshot for better understanding:

 Data Decimal.PNG
Thank you in advance.

 

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

Hi @P_Kiranmai123 ,

 

There are two ways that you could change decimal places.

 

One is in Measure/Column tools that they suggests. 

 

v-xuding-msft_0-1598861477939.png

 

Another one is in model view. 

6.PNG

 

(If you want to show custom format, please reference the document: Use custom format strings in Power BI Desktop )

 

 

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

View solution in original post

3 REPLIES 3
v-xuding-msft
Community Support
Community Support

Hi @P_Kiranmai123 ,

 

There are two ways that you could change decimal places.

 

One is in Measure/Column tools that they suggests. 

 

v-xuding-msft_0-1598861477939.png

 

Another one is in model view. 

6.PNG

 

(If you want to show custom format, please reference the document: Use custom format strings in Power BI Desktop )

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

@P_Kiranmai123 , fix decimal place in column/measure tool

 

Data Format New Rib.png

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Pragati11
Super User
Super User

Hi @P_Kiranmai123 ,

 

A single masure or a single column can only have one set of rules around data display.

 

Suppose you have a decimal measure - MEASURE1

It's data-type id DECIMAL

Number of decimal places = 2.

 

So for the calculations you will see the value upto 2 decimal places. You can have one with 1 decimal place and other with 2 decimal place.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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