JSON File Help

[Anonymous]

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

[Gazzer · Accepted 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.

[Anonymous]

That worked!

Thank you so much. I had been looking for a place to validate .json files. Greatly appreciated.