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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
vgeldbr
Helper IV
Helper IV

Setting default decimal places in matrix table using theme

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
					}
				],

 

4 REPLIES 4
PaulDBrown
Community Champion
Community Champion

In theory you should be using measures for value fields, and measures are formatted individually





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

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.

 

image.png

image.png

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?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.