Graph horizontal gridlines in JSON theme file.

[QuinnP]

Hey all,

Quick question: does anyone know if there's a field for formatting the horizontal gridlines on visuals like column charts and area charts within the JSON theme syntax? The only grid options I've found have been in relation to tables/matrices and haven't carried over to charts. This update which said 'With this month’s update, all visual properties can be formatted through theming, with the exception of properties that require data in advanced' makes me think that there must be a property somewhere that I can't find!

Cheers,

Quinn

[v-shex-msft · Accepted solution]

HI @QuinnP ,

I create a custom theme with 'gridline' settings on visuals which you mentioned and import to power bi, but it seems not enabled correctly.

{
   "name":"My Theme",
   "visualStyles":{
      "*":{
         "*":{
            "*":[
               {
                  "color":{
                     "solid":{

                     }
                  }
               }
            ]
         }
      },
      "columnChart":{
         "*":{
            "categoryAxis":[
               {
                  "show":true,
                  "gridlineStyle":"dotted",
                  "labelColor":{
                     "solid":{
                        "color":"#000000"
                     }
                  }
               }
            ]
         }
      },
      "clusteredColumnChart":{
         "*":{
            "categoryAxis":[
               {
                  "show":true,
                  "gridlineStyle":"dotted",
                  "labelColor":{
                     "solid":{
                        "color":"#000000"
                     }
                  }
               }
            ]
         }
      },
      "AreaChart":{
         "*":{
            "categoryAxis":[
               {
                  "show":true,
                  "gridlineStyle":"dotted",
                  "labelColor":{
                     "solid":{
                        "color":"#000000"
                     }
                  }
               }
            ]
         }
      },
      "stackedAreaChart":{
         "*":{
            "categoryAxis":[
               {
                  "show":true,
                  "gridlineStyle":"dotted",
                  "labelColor":{
                     "solid":{
                        "color":"#000000"
                     }
                  }
               }
            ]
         }
      }
   }
}

I guess these properties haven't released so that power bi not allow you to modify them based on theme settings.

Regards,

Xiaoxin Sheng