Forum Discussion

QuinnP's avatar
QuinnP
Advocate II
6 years ago
Solved

Graph horizontal gridlines in JSON theme file.

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 opti...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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