Forum Discussion
Custom Report Theme JSON Property settings in Tables/Matrix
- 8 years ago
Hey Everyone,
Microsoft has gotten back with me and said
"Our product team have fixed this issue and code check-in has been done.
Product team confirmed that this fix will be available in the service in about 3 weeks and this fix will be available in December version of Power BI Desktop."
Looks like most or all of the properties that don't work now will work in the December release! ....To Be Continued...
10/25 update:
I got another response back-
" My product team confirmed that the JSON file that you have developed is correct. They have fixed bugs in Power BI Desktop which rendered properly based on the JSON file."
looks like we can take my original example as correct as far as the properties of the "grid" card are concerned. Here's to changing more properties by JSON theme files in December!

11/1 Update:
OK so the Microsoft team told me specifically that the only issues that will be fixed are the ones that are brought to their team via support tickets. So if you see something that doesn't work SEND IT IN! They said in order to keep track of what needs fixing they will only fix issues brought to their attention. I already sent in all the ones that don't work for my use case but that will not cover all the other JSON properties not working. Someone needs to do a giant test of all the properties and then send in a huge ticket :smileylol:
12/12 Update:
The December release is out and as far as I can tell, there has been no changes as far as the JSON features working. I reached out to the MS team to troubleshoot. hopefully its user error and I just need to change my JSON. :smileymad:
Jan 2018 Update:
Apparently the JSON features I requested to be fixed WERE fixed but they weren't working the way they originally told me they would! This works for me and fulfills my requirements for my original post:
{ "name":"Jan 2018 Theme", "dataColors":[ "#0069aa", "#4f8dc2", "#9ab7da", "#cedaec", "#00c762", "#fbe7a6", "#ff544a", "#f89a1c", "#545451" ], "background":"#FFFFFF", "foreground":"#545451", "tableAccent":"#4f8dc2", "visualStyles":{ "*":{ "*":{ "*":[ { "fontFamily":"Segoe UI" } ] } }, "*":{ "*":{ "grid":[ { "outlineColor":{"solid":{"color":"#4f8dc2"}}, "gridVertical":true, "gridVerticalColor":{"solid":{"color":"#4f8dc2"}}, "gridHorizontal":true, "gridHorizontalColor":{"solid":{"color":"#4f8dc2"}} } ], "columnHeaders":[ { "fontColor":{"solid":{"color":"#ffffff"}}, "backColor":{"solid":{"color":"#0069aa"}}, "fontFamily":"Segoe UI" } ], "values":[ { "backColorSecondary":{"solid":{"color":"#cedaec"}} } ] } } } }
Hey Everyone,
Microsoft has gotten back with me and said
"Our product team have fixed this issue and code check-in has been done.
Product team confirmed that this fix will be available in the service in about 3 weeks and this fix will be available in December version of Power BI Desktop."
Looks like most or all of the properties that don't work now will work in the December release! ....To Be Continued...
10/25 update:
I got another response back-
" My product team confirmed that the JSON file that you have developed is correct. They have fixed bugs in Power BI Desktop which rendered properly based on the JSON file."
looks like we can take my original example as correct as far as the properties of the "grid" card are concerned. Here's to changing more properties by JSON theme files in December! 
11/1 Update:
OK so the Microsoft team told me specifically that the only issues that will be fixed are the ones that are brought to their team via support tickets. So if you see something that doesn't work SEND IT IN! They said in order to keep track of what needs fixing they will only fix issues brought to their attention. I already sent in all the ones that don't work for my use case but that will not cover all the other JSON properties not working. Someone needs to do a giant test of all the properties and then send in a huge ticket :smileylol:
12/12 Update:
The December release is out and as far as I can tell, there has been no changes as far as the JSON features working. I reached out to the MS team to troubleshoot. hopefully its user error and I just need to change my JSON. :smileymad:
Jan 2018 Update:
Apparently the JSON features I requested to be fixed WERE fixed but they weren't working the way they originally told me they would! This works for me and fulfills my requirements for my original post:
{
"name":"Jan 2018 Theme",
"dataColors":[
"#0069aa",
"#4f8dc2",
"#9ab7da",
"#cedaec",
"#00c762",
"#fbe7a6",
"#ff544a",
"#f89a1c",
"#545451"
],
"background":"#FFFFFF",
"foreground":"#545451",
"tableAccent":"#4f8dc2",
"visualStyles":{
"*":{
"*":{
"*":[
{
"fontFamily":"Segoe UI"
}
]
}
},
"*":{
"*":{
"grid":[
{
"outlineColor":{"solid":{"color":"#4f8dc2"}},
"gridVertical":true,
"gridVerticalColor":{"solid":{"color":"#4f8dc2"}},
"gridHorizontal":true,
"gridHorizontalColor":{"solid":{"color":"#4f8dc2"}}
}
],
"columnHeaders":[
{
"fontColor":{"solid":{"color":"#ffffff"}},
"backColor":{"solid":{"color":"#0069aa"}},
"fontFamily":"Segoe UI"
}
],
"values":[
{
"backColorSecondary":{"solid":{"color":"#cedaec"}}
}
]
}
}
}
}
- KellyDittmar8 years agoAdvocate IV
Fantastic!! Thanks for following up with them & with us!
- Anonymous4 years agoNot applicable
Pivot Table:
"pivotTable": {
"*": {
"stylePreset":[{
"name":"AlternatingRows"
}],
"grid": [{
"gridVertical": false,
"gridVerticalColor": { "solid": { "color": "#E6E6E6"}},
"gridVerticalWeight": 1,
"gridHorizontal": true,
"gridHorizontalColor": { "solid": { "color": "#E6E6E6"}},
"gridHorizontalWeight": 1,
"rowPadding": 1,
"outlineColor": { "solid": { "color": "#E6E6E6"}},
"outlineWeight": 2,
"textSize": 10,
"imageHeight": 75
}],
"columnHeaders": [{
"fontColor": { "solid": { "color": "#FFFFFF"}},
"backColor": { "solid": { "color": "#003D6A"}},
"outline": "Bottom",
"autoSizeColumnWidth": true,
"fontFamily": "Segoe UI",
"fontSize": 11,
"alignment": "Center",
"titleAlignment": "Left",
"urlIcon": false,
"wordWrap": false,
"bold": false,
"italic": false,
"underline": false
}],
"rowHeaders": [{
"fontColor": { "solid": { "color": "#000000"}},
"backColor": { "solid": { "color": "#FFFFFF"}},
"outline": "Right",
"stepped": true,
"steppedLayoutIndentation": 20,
"urlIcon": false,
"wordWrap": true,
"fontFamily": "Segoe UI",
"fontSize": 11,
"alignment": "Auto",
"bold": false,
"italic": false,
"underline": false,
"showExpandCollapseButtons":true,
"expandCollapseButtonsColor": { "solid": { "color": "#000000"}},
"expandCollapseButtonsSize": 10
}],
"values": [{
"fontColorPrimary": { "solid": { "color": "#000000"}},
"backColorPrimary": { "solid": { "color": "#FFFFFF"}},
"fontColorSecondary": { "solid": { "color": "#000000"}},
"backColorSecondary": { "solid": { "color": "#FFFFFF"}},
"bandedRowHeaders": true,
"valuesOnRow": false,
"outline": "None",
"urlIcon": false,
"wordWrap": true,
"fontFamily": "Segoe UI",
"fontSize": 10,
"bold": false,
"italic": false,
"underline": false
}],
"subTotals": [{
"rowSubtotals": true,
"columnSubtotals": true,
"fontColor": { "solid": { "color": "#000000"}},
"fontFamily": "Segoe UI",
"backColor": { "solid": { "color": "#FFFFFF"}},
"fontSize": 10,
"applyToHeaders": false,
"rowSubtotalsPosition": "Top",
"perRowLevel": false,
"perColumnLevel": false
}],
"total": [{
"fontColor": { "solid": { "color": "#000000"}},
"fontFamily": "Segoe UI Bold",
"backColor": { "solid": { "color": "#CCCCCC"}},
"applyToHeaders": true,
"fontSize": 10
}]
}
}If you want a goo resource for templates for all the various charts and elements check out: https://github.com/deldersveld/PowerBI-ThemeTemplates
Most everything you need is in there. There are some additional properties that are not highlighted and you have to dig for the name for any custom or imported element. - ruthpozuelo8 years agoKudo Kingpin
ok, so these doesnt work yet for pivotTable?
"values": [{
"fontColorPrimary":"#203461",
"backColorPrimary":"#203461",
"fontColorSecondary":"#203461",
"backColorSecondary":"#f3fafe",
}],Not a smooth process...
/Ruth
- ruthpozuelo8 years agoKudo Kingpin
ok, so these doesnt work yet for pivotTable?
"values": [{
"fontColorPrimary":"#203461",
"backColorPrimary":"#203461",
"fontColorSecondary":"#203461",
"backColorSecondary":"#f3fafe",
}],Not a smooth process...
/Ruth