Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Serafin54
New Member

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
}]
}
}
}}}

 

 

1 ACCEPTED SOLUTION
hackcrr
Super User
Super User

@Serafin54 

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!

View solution in original post

2 REPLIES 2
hackcrr
Super User
Super User

@Serafin54 

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.