Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 }] } } } }
Solved! Go to 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 }] } } } }
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |