cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sfuhr Frequent Visitor
Frequent Visitor

Change table design with JSON theme

Hello -

 

i have the challenge to modify some colors to match our CI guidelines - using tables and matrix in Power BI i need to change the background color of the column headers. I tried the following JSON input:

 

{
"name":"test design",
"dataColors": [ "#004459", "#54B7C6", "#AB0953", "#BAC405", "#667C72", "#633A11", "#006686", "#AB0953" ],
"background":"#F5F8FC",
"foreground":"#003366",
"tableAccent":"#214F80",

"visualStyles": {

	"tableEx": {
			"*": {	
				"columnHeaders": [{
				            "backColor":"#004459",
				            "fontColor":"#ffffff",
							"wordWrap":false,
							"fontSize":9,
				            "urlIcon":true
                            }],
					"values": [{
							"wordWrap":false,
							"fontSize":8,
						    "urlIcon":true
                            }]
						}
				}
			}
	}

Syntax seems to be ok - font size and other parameters changing - "backColor" is not working at all. Any thoughts what i'm doing wrong or is it a bug?

 

Many thanks and best regards,

Stephan

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Change table design with JSON theme

I was able to use this to change the background color of my table headers:

 

{"name":"My Theme","visualStyles":{"*":{"*":{"*":[{"color":{"solid":{}}}]}},"tableEx":{"*":{"columnHeaders":[{"backColor":{"solid":{"color":"#123456"}}}]}}}}


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

3 REPLIES 3
Super User
Super User

Re: Change table design with JSON theme

I was able to use this to change the background color of my table headers:

 

{"name":"My Theme","visualStyles":{"*":{"*":{"*":[{"color":{"solid":{}}}]}},"tableEx":{"*":{"columnHeaders":[{"backColor":{"solid":{"color":"#123456"}}}]}}}}


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

sfuhr Frequent Visitor
Frequent Visitor

Re: Change table design with JSON theme

Great - works perfect! Thanks a lot @Greg_Deckler 

 

best regards,

Stephan

Highlighted
Super User
Super User

Re: Change table design with JSON theme

No problem, I recommend @Mike_Carlo's https://powerbi.tips for this. Use the Advanced Theme Generator to stitch together the right syntax!


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 415 members 3,575 guests
Please welcome our newest community members: