Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi team,
I am lost, I try to change these Matrix setting via JSON:
Here is my try, but nothing happens:
{
...."name": "Matrix",
...."visualStyles": {
........"*": {
............"*": {
................"rowHeaders": [
....................{
........................"outline": "None"
....................}
................]
............}
........},
........"pivotTable": {
............"*": {
................"rowHeaders": [
....................{
........................"outline": "None"
....................}
................]
............}
........}
....}
}
Any idea?
Best, Thomas
Hi @kastenfrosch ,
Here is a solved post with similar requirement like yours.
You may refer to this code to learn more details.
{
"name":"Jan 2018 Theme",
"dataColors":[
"#0069aa",
"#4f8dc2",
"#9ab7da",
"#cedaec",
"#00c762",
"#fbe7a6",
"#ff544a",
"#f89a1c",
"#545451"
],
"background":"#FFFFFF",
"foreground":"#545451",
"tableAccent":"#4f8dc2",
"visualStyles":{
"*":{
"*":{
"*":[
{
"fontFamily":"Segoe UI"
}
]
}
},
"*":{
"*":{
"grid":[
{
"outlineColor":{"solid":{"color":"#4f8dc2"}},
"gridVertical":true,
"gridVerticalColor":{"solid":{"color":"#4f8dc2"}},
"gridHorizontal":true,
"gridHorizontalColor":{"solid":{"color":"#4f8dc2"}}
}
],
"columnHeaders":[
{
"fontColor":{"solid":{"color":"#ffffff"}},
"backColor":{"solid":{"color":"#0069aa"}},
"fontFamily":"Segoe UI"
}
],
"values":[
{
"backColorSecondary":{"solid":{"color":"#cedaec"}}
}
]
}
}
}
}
I hope it could help you solve your problem.
If you want a good resource for templates for all the various charts and elements check out:
PowerBI-ThemeTemplates
Most everything you need is in there. There are some additional properties that are not highlighted and you have to dig for the name for any custom or imported element.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rico,
Thank you for your support! I have already used the GitHub link that you have provided for reference. My approach is taken from these examples at GitHub. Unfortunately, it doesn't work (anymore?).
Any other idea? Best, Thomas