Specific Column formatting in matrix visual with JSON theme

[LuciaK]

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! 🙂

[Petr_Tvoremirov]

Could not find the solution as well.

Specific column is not part of JSON at all ☹️

[Idrissshatila]

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

[LuciaK]

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.