Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |