Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Any ideas how to set the default number of decimal places under "Field formatting" in a matrix table? It is "Auto" by default and I'm trying to set it to zero without luck in my JSON theme file. I believe have to use something like this but it is not working:
"pivotTable": {
"*": {
"columnFormatting": [
{
"labelPrecision": 0
}
],
In theory you should be using measures for value fields, and measures are formatted individually
Proud to be a Super User!
Paul on Linkedin.
Agreed but in this case I have a lot of measures and they are also used elsewhere in drill-through pages where the decimal places are required. So I want to set the display of the number of decimal places in the specific visuals. In this case the matrix table but potentially also in cards and other visuals.
Hi @vgeldbr ,
I don't find appropriate code to set default decimal places in matrix using theme. In my test, when you set decimal places in Field formatting for your measures, it doesn't affect decimal places these measures display in other visuals. This is a screenshot of my test.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-kkf-msft . There is no error, it just does not work. It looks to me as if it is not possible to set defaults under columnFormatting perhaps because the selections could be different for each field used?
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 50 | |
| 40 | |
| 37 | |
| 14 | |
| 14 |
| User | Count |
|---|---|
| 85 | |
| 69 | |
| 38 | |
| 29 | |
| 27 |