Forum Discussion
custom columnHeaders not working
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 }] } } } }
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.
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 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 }] } } } }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.