Forum Discussion
JSON formatting textbox not working
Hello,
I am beginning building a theme json file and testing as I go. My current file loads fine but the textbox formatting doesn't update in Powerbi. It appears to be following the visualStyles rather than the detailed "textbox" parameters. I have tried to move it into the visualStyles block to see if that would help but it doesn't. Is there a piece of code I am missing or does this not work any longer?
{
"name": "PEO PSA",
"dataColors": [
"#4A8DDC",
"#4C5D8A",
"#F3C911",
"#DC5B57",
"#33AE81",
"#95C8F0",
"#DD915F",
"#9A64A0",
"#6EA4E3",
"#707DA1",
"#F5D441",
"#E37C79",
"#5CBE9A",
"#AAD3F3",
"#E4A77F",
"#AE83B3",
"#386AA5",
"#394668",
"#B6970D",
"#A54441",
"#268361",
"#7096B4",
"#A66D47",
"#744B78",
"#25476E",
"#262F45",
"#7A6509",
"#6E2E2C",
"#1A5741",
"#4B6478",
"#6F4930",
"#4D3250"
],
"background": "#FFFFFF",
"foreground": "#070f25",
"tableAccent": "#0F1934",
"textClasses": {
"label": {
"color": "#386AA5",
"fontSize": 12
},
"callout": {
"fontFace": "'Segoe UI', wf_segoe-ui_normal, helvetica, arial, sans-serif"
},
"title": {
"color": "#386AA5",
"fontFace": "'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
}
},
"visualStyles": {
"*": {
"*": {
"border": [
{
"color": {
"solid": {
"color": "#25476E"
}
},
"show": true,
"radius": 1
}
],
"outspacePane": [
{
"checkboxAndApplyColor": {
"solid": {
"color": "#080909"
}
}
}
]
},
"textbox": {
"*": {
"*": [
{
"fontSize": 40,
"fontFamily": "Calibri",
"wordWrap": true,
"color": { "solid": { "color": "#FFFFFF"} }
}],
"general": [
{
"responsive": true
}
],
"background": [{
"show": true,
"color": { "solid": { "color": "#386AA55"}},
"transparency": 0
}],
"visualHeader": [
{
"show": false
}]
}
}
}}}
Here's a refined version of your JSON:
{ "name": "PEO PSA", "dataColors": [ "#4A8DDC", "#4C5D8A", "#F3C911", "#DC5B57", "#33AE81", "#95C8F0", "#DD915F", "#9A64A0", "#6EA4E3", "#707DA1", "#F5D441", "#E37C79", "#5CBE9A", "#AAD3F3", "#E4A77F", "#AE83B3", "#386AA5", "#394668", "#B6970D", "#A54441", "#268361", "#7096B4", "#A66D47", "#744B78", "#25476E", "#262F45", "#7A6509", "#6E2E2C", "#1A5741", "#4B6478", "#6F4930", "#4D3250" ], "background": "#FFFFFF", "foreground": "#070f25", "tableAccent": "#0F1934", "textClasses": { "label": { "color": "#386AA5", "fontSize": 12 }, "callout": { "fontFace": "'Segoe UI', wf_segoe-ui_normal, helvetica, arial, sans-serif" }, "title": { "color": "#386AA5", "fontFace": "'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif" } }, "visualStyles": { "textbox": { "*": { "general": [{ "responsive": true }], "title": [{ "fontSize": 40, "fontFamily": "Calibri", "wordWrap": true, "color": { "solid": { "color": "#FFFFFF"} } }], "background": [{ "show": true, "color": { "solid": { "color": "#386AA5"} }, "transparency": 0 }], "visualHeader": [{ "show": false }] } }, "*": { "*": { "border": [ { "color": { "solid": { "color": "#25476E" } }, "show": true, "radius": 1 } ], "outspacePane": [ { "checkboxAndApplyColor": { "solid": { "color": "#080909" } } } ] } } } }hackcrr
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!
2 Replies
Here's a refined version of your JSON:
{ "name": "PEO PSA", "dataColors": [ "#4A8DDC", "#4C5D8A", "#F3C911", "#DC5B57", "#33AE81", "#95C8F0", "#DD915F", "#9A64A0", "#6EA4E3", "#707DA1", "#F5D441", "#E37C79", "#5CBE9A", "#AAD3F3", "#E4A77F", "#AE83B3", "#386AA5", "#394668", "#B6970D", "#A54441", "#268361", "#7096B4", "#A66D47", "#744B78", "#25476E", "#262F45", "#7A6509", "#6E2E2C", "#1A5741", "#4B6478", "#6F4930", "#4D3250" ], "background": "#FFFFFF", "foreground": "#070f25", "tableAccent": "#0F1934", "textClasses": { "label": { "color": "#386AA5", "fontSize": 12 }, "callout": { "fontFace": "'Segoe UI', wf_segoe-ui_normal, helvetica, arial, sans-serif" }, "title": { "color": "#386AA5", "fontFace": "'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif" } }, "visualStyles": { "textbox": { "*": { "general": [{ "responsive": true }], "title": [{ "fontSize": 40, "fontFamily": "Calibri", "wordWrap": true, "color": { "solid": { "color": "#FFFFFF"} } }], "background": [{ "show": true, "color": { "solid": { "color": "#386AA5"} }, "transparency": 0 }], "visualHeader": [{ "show": false }] } }, "*": { "*": { "border": [ { "color": { "solid": { "color": "#25476E" } }, "show": true, "radius": 1 } ], "outspacePane": [ { "checkboxAndApplyColor": { "solid": { "color": "#080909" } } } ] } } } }hackcrr
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!
Thank you. So if I am not mistaken, it was an ordering issue? I was able to use your code and build off it as I noticed that the font still wouldn't show up properly with the coloring scheme but that was an easy fix using "fontColor" instead of the "Color" I had previously coded. Thanks for the assistance.
