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.
Hello all,
I am trying to create a new .json file for my Power BI Theme. My theme was working until I entered in the "Grid" and "columnHeaders" below. Can someone tell me where I am running into errors? Below is the .json file info.
{
"background": "#FAFAFA",
"dataColors": [
"#0e3c54",
"#E68223",
"#5fada4",
"#eb534b",
"#facb18",
"#39414b",
"#4c7334",
"#858585"
],
"foreground": "#0e3c54",
"name": "WinField Analytics",
"tableAccent": "#CDD2D9",
"visualStyles": {
"*": {
"*": {
"*": [
{
"fontFamily": "Arial"
}
],
"legend": [
{
"showTitle": false
}
],
"grid":[
{
"outlineColor":{"solid":{"color":"#EB534B"}},
"gridVertical":true,
"gridVerticalColor":{"solid":{"color":"#2B3138"}},
"gridHorizontal":true,
"gridHorizontalColor":{"solid":{"color":"#39414B"}}
}
],
"columnHeaders":[
{
"fontColor":{"solid":{"color":"#ffffff"}},
"backColor":{"solid":{"color":"#39414B"}},
"fontFamily":"Arial"
}
],
}
}
"card": {
"*": {
"categoryLabels": [
{
"show": false
}
],
"labels": [
{
"fontSize": 28
}
]
}
},
"donutChart": {
"*": {
"labels": [
{
"show": false
}
],
"legend": [
{
"position": "RightCenter",
"show": true
}
]
}
},
"gauge": {
"*": {
"labels": [
{
"fontSize": 12
}
]
}
},
"multiRowCard": {
"*": {
"card": [
{
"barWeight": 5
}
],
"categoryLabels": [
{
"fontSize": 11
}
],
"dataLabels": [
{
"fontSize": 28
}
]
}
},
"pieChart": {
"*": {
"labels": [
{
"labelStyle": "Percent of total"
}
],
"legend": [
{
"position": "RightCenter",
"show": true
}
]
}
},
"slicer": {
"*": {
"header": [
{
"textSize": 11
}
]
}
}
}
}
Solved! Go to Solution.
It looks like the issue is the comma and brackets, just before 'card' - the comma should be after the brackets:
{ "background":"#FAFAFA", "dataColors":[ "#0e3c54", "#E68223", "#5fada4", "#eb534b", "#facb18", "#39414b", "#4c7334", "#858585" ], "foreground":"#0e3c54", "name":"WinField Analytics", "tableAccent":"#CDD2D9", "visualStyles":{ "*":{ "*":{ "*":[ { "fontFamily":"Arial" } ], "legend":[ { "showTitle":false } ], "grid":[ { "outlineColor":{ "solid":{ "color":"#EB534B" } }, "gridVertical":true, "gridVerticalColor":{ "solid":{ "color":"#2B3138" } }, "gridHorizontal":true, "gridHorizontalColor":{ "solid":{ "color":"#39414B" } } } ], "columnHeaders":[ { "fontColor":{ "solid":{ "color":"#ffffff" } }, "backColor":{ "solid":{ "color":"#39414B" } }, "fontFamily":"Arial" } ] } }, "card":{ "*":{ "categoryLabels":[ { "show":false } ], "labels":[ { "fontSize":28 } ] } }, "donutChart":{ "*":{ "labels":[ { "show":false } ], "legend":[ { "position":"RightCenter", "show":true } ] } }, "gauge":{ "*":{ "labels":[ { "fontSize":12 } ] } }, "multiRowCard":{ "*":{ "card":[ { "barWeight":5 } ], "categoryLabels":[ { "fontSize":11 } ], "dataLabels":[ { "fontSize":28 } ] } }, "pieChart":{ "*":{ "labels":[ { "labelStyle":"Percent of total" } ], "legend":[ { "position":"RightCenter", "show":true } ] } }, "slicer":{ "*":{ "header":[ { "textSize":11 } ] } } } }
I pasted your JSON into here to validate it:
https://jsonformatter.curiousconcept.com/
Note that I have not tested or validated that it will give you what you need, but it is at least valid JSON now.
It looks like the issue is the comma and brackets, just before 'card' - the comma should be after the brackets:
{ "background":"#FAFAFA", "dataColors":[ "#0e3c54", "#E68223", "#5fada4", "#eb534b", "#facb18", "#39414b", "#4c7334", "#858585" ], "foreground":"#0e3c54", "name":"WinField Analytics", "tableAccent":"#CDD2D9", "visualStyles":{ "*":{ "*":{ "*":[ { "fontFamily":"Arial" } ], "legend":[ { "showTitle":false } ], "grid":[ { "outlineColor":{ "solid":{ "color":"#EB534B" } }, "gridVertical":true, "gridVerticalColor":{ "solid":{ "color":"#2B3138" } }, "gridHorizontal":true, "gridHorizontalColor":{ "solid":{ "color":"#39414B" } } } ], "columnHeaders":[ { "fontColor":{ "solid":{ "color":"#ffffff" } }, "backColor":{ "solid":{ "color":"#39414B" } }, "fontFamily":"Arial" } ] } }, "card":{ "*":{ "categoryLabels":[ { "show":false } ], "labels":[ { "fontSize":28 } ] } }, "donutChart":{ "*":{ "labels":[ { "show":false } ], "legend":[ { "position":"RightCenter", "show":true } ] } }, "gauge":{ "*":{ "labels":[ { "fontSize":12 } ] } }, "multiRowCard":{ "*":{ "card":[ { "barWeight":5 } ], "categoryLabels":[ { "fontSize":11 } ], "dataLabels":[ { "fontSize":28 } ] } }, "pieChart":{ "*":{ "labels":[ { "labelStyle":"Percent of total" } ], "legend":[ { "position":"RightCenter", "show":true } ] } }, "slicer":{ "*":{ "header":[ { "textSize":11 } ] } } } }
I pasted your JSON into here to validate it:
https://jsonformatter.curiousconcept.com/
Note that I have not tested or validated that it will give you what you need, but it is at least valid JSON now.
That worked!
Thank you so much. I had been looking for a place to validate .json files. Greatly appreciated.
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |