cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

JSON File Help

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

 

 

1 ACCEPTED SOLUTION
Gazzer
Resolver II
Resolver II

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.

View solution in original post

2 REPLIES 2
Gazzer
Resolver II
Resolver II

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.

View solution in original post

Anonymous
Not applicable

That worked!

 

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!