Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |