custom columnHeaders not working

[alexlopesBS]

Hi, 

I've been trying to make a columnHeader customization to a theme at my work, but it doesn't apply. I would like column header to be by default front: white, back: "#333", can anyone assist me on why it doesnt apply?

Here is the code:

{
    "name": "LASA",
    "dataColors": [ "#FF0000", "#7F2626", "#2F343B", "#374649", "#333333",  "#5F6B6D", "#FD625E"], 
    "background":"#FFFFFF",
    "foreground": "#333333",
    "tableAccent": "#FF0000",
    "visualStyles": {
        "*": {
            "*": {
                "*": [{
                    "responsive":true,
                    "wordWrap":true,
                    "fontFamily": "Segoe UI",
                    "fontColor": "#333333",
                    "labelColor": {
                        "solid": {
                            "color": "#333333"
                        }
                    }                   
                }],
                "legend": [{
                    "fontSize": 11,
                    "color": "#333333",
                    "fontFamily": "wf_segoe-ui_bold"
                }],
                "labels": [{
                    "color": {
                        "solid": {
                            "color": "#333333"
                        }
                    }
                }],
                "columnHeaders": [{
                    "backColor": {
                        "solid": {
                            "color": "#333333"
                        }
                    },
                    "fontColor": "#FFFFFF",
                    "outline": 0
                }]
            }
        },
        "card": {
            "*": {
                "labels": [{
                    "fontSize":35,
                    "fontFamily": "wf_segoe-ui_bold",
                    "color": {
                        "solid": {
                            "color": "#FF0000"
                        }
                    }
                }],
                "categoryLabels": [{
                    "show":false
                }]
            }
        }
    }
}

[Greg_Deckler]

Hmm, the definite guide for themes that I could find seems to be here:

https://docs.microsoft.com/en-us/power-bi/desktop-report-themes

Couldn't see anything obviously wrong. Will have to spend a little time looking at it.

[alexlopesBS]

I was able to make the colors work after moving the parameters to the specific visualName "tableEx", but the outline and autoSizeColumnWidth values still doesn't work, I will try different keys with bracers and see if I can figure it out.

The documentation is a bit incomplete, unfortunately. 😞

"tableEx": {
            "*" : {
                "columnHeaders": [{
                    "backColor": {
                        "solid": {
                            "color": "#333333"
                        }
                    },
                    "fontColor": {
                        "solid": {
                            "color": "#FFFFFF"
                        }
                    },
                    "outline": 0,
                    "autoSizeColumnWidth": 1
                }]
            }
        },

[alexlopesBS · Accepted solution]

---

@alexlopesBS wrote:

I will try different keys with bracers and see if I can figure it out.

---

Well, it turns out you have to use the "value" key inside the parameters if you want it to work. 

"tableEx": {
            "*" : {
                "columnHeaders": [{
                    "backColor": {
                        "solid": {
                            "color": "#333333"
                        }
                    },
                    "fontColor": {
                        "solid": {
                            "color": "#FFFFFF"
                        }
                    },
                    "outline": { "value": 0 },
                    "autoSizeColumnWidth": { "value": 1 }
                }]
            }
        },

Here is the fixed full code for future reference.

{
    "name": "LASA",
    "dataColors": [ "#FF0000", "#7F2626", "#2F343B", "#374649", "#333333",  "#5F6B6D", "#FD625E"], 
    "background":"#FFFFFF",
    "foreground": "#333333",
    "tableAccent": "#FF0000",
    "visualStyles": {
        "*": {
            "*": {
                "*": [{
                    "responsive":true,
                    "wordWrap":true,
                    "fontFamily": "Segoe UI",
                    "fontColor": "#333333",
                    "labelColor": {
                        "solid": {
                            "color": "#333333"
                        }
                    }                   
                }],
                "legend": [{
                    "fontSize": 11,
                    "color": "#333333",
                    "fontFamily": "wf_segoe-ui_bold"
                }]
            }
        },
        "tableEx": {
            "*" : {
                "columnHeaders": [{
                    "backColor": {
                        "solid": {
                            "color": "#333333"
                        }
                    },
                    "fontColor": {
                        "solid": {
                            "color": "#FFFFFF"
                        }
                    },
                    "outline": { "value": 0 },
                    "autoSizeColumnWidth": { "value": 1 }
                }]
            }
        },
        "card": {
            "*": {
                "labels": [{
                    "fontSize":35,
                    "fontFamily": "wf_segoe-ui_bold",
                    "color": {
                        "solid": {
                            "color": "#FF0000"
                        }
                    }
                }],
                "categoryLabels": [{
                    "show":false
                }]
            }
        }
    }
}

[Greg_Deckler]

Awesome, thanks for following up on this, I agree that the documentation is a bit of a mess. I think what would be really helpful would be for the Power BI team to publish an example theme that literally has every possible thing that you could ever want to customize in it and then everyone could just grab elements that they wanted from that.