Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
92 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |