Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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:
Thank you in advance.
Solved! Go to Solution.
Hi @P_Kiranmai123 ,
There are two ways that you could change decimal places.
One is in Measure/Column tools that they suggests.
Another one is in model view.
(If you want to show custom format, please reference the document: Use custom format strings in Power BI Desktop )
Hi @P_Kiranmai123 ,
There are two ways that you could change decimal places.
One is in Measure/Column tools that they suggests.
Another one is in model view.
(If you want to show custom format, please reference the document: Use custom format strings in Power BI Desktop )
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.