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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
LuciaK
New Member

Specific Column formatting in matrix visual with JSON theme

Hi everyone,

I would like to ask. Is it possible to define formatting for specific column for matrix visual in JSON file?
I tried this:
"pivotTable": {
"*": {
"columnFormatting": [
{
"styleHeader": true,
"styleSubtotals": false,
"styleTotal": false,
"styleValues": false,
"alignment": "Left",
"backColor": {
"solid": {
"color": {
"expr": {
"ThemeDataColor": {
"ColorId": 1,
"Percent": 0
}
and this one:
"pivotTable": {
"*": {
"columnFormatting": [
{"properties":{
"backColor":{"solid":{"color":{"expr":{"Literal":{"Value":"#E6E6E6"}}}}},
"styleSubtotals":false,
"styleValues":false,
"styleHeader":true,
"alignment":"Center"},
"selector":{"metadata":"Calculations.PY*"}},

but it's not working at all.

Thanks a lot! 🙂

3 REPLIES 3
Petr_Tvoremirov
Regular Visitor

Could not find the solution as well.

Specific column is not part of JSON at all ☹️

Idrissshatila
Super User
Super User

Hello @LuciaK ,

 

You could easily specify it on the visual itself by each column.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Hello @Idrissshatila 
I know but we have many reports with the same formatting for matrix visuals so it'll be very helpful to have it defined once in the theme template.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 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.

Top Solution Authors
Top Kudoed Authors