Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
janstrauss1
Advocate I
Advocate I

Setting table grid border position via custom json report theme

Dear PowerBi Community,

 

I'm trying to develop a custom PowerBi report json theme according to the Corporate Identity (CI) of the organisation that I work for.

 

While I have come across a very helpful github repository at https://github.com/MattRudy/PowerBI-ThemeTemplates, I'm currently struggling to get the tables to look as required by our CI without manual formatting via 'Format visual' using a custom json theme.

 

According to our CI design tables should have a reddish grid border on the left of the table as shown in the example table below that I can easily achieve via manual formatting as shown:

 

TableWanted.PNGFormatVisual.PNG

 

What I'm currently getting based on my json code snippet below is the following table with reddish grid borders at the top and bottom as shown in the follwong example table:

 

Table.PNG

 

 

 

 

 

 

 

 

 

How do I set the table grid border position in my json file?

I tried via "grid":[{"outline":"LeftOnly"}] but it doesn't seem to have any effect...

 

Any pointers and suggestions how to set the table grid border position via json would be highly appreciated so that I don't need to manually edit all tables in my reports.

 

Many thanks in advance!

 

JSON theme code

 

"tableEx": {
            "*": {
                "general": [{
                    "responsive": true,
                    "keepLayerOrder": true
                    }],
                "stylePreset": [{ 
                    "name": "ContrastAlternatingRows"
                    }],
                "background": [{
                    "show": false,
					"color": { "solid": { "color": "#ffffff"}},
					"transparency": 0
				}],
				"border": [{
                    "show": false,
					"color": { "solid": { "color": "#d17559"}},
					"radius": 0
				}],
				"title": [{
					"show": true,
					"fontColor": { "solid": { "color": "#d17559" } },
					"background": { "solid": { "color": "#ffffff" } },
					"alignment": "left"
				}],
				"grid": [{
					"gridVertical": false,
					"gridVerticalColor": { "solid": { "color": "#d17559"}},
					"gridVerticalWeight": 1,
					"gridHorizontal": false,
					"gridHorizontalColor": { "solid": { "color": "#ffffff"}},
					"gridHorizontalWeight": 1,
					"rowPadding": 1,
					"outlineColor": { "solid": { "color": "#d17559"}},
					"outlineWeight": 1,
                    "outline": "LeftOnly",
					"textSize": 12,
					"imageHeight": 100
				}],
				"columnHeaders": [{
					"fontColor": { "solid": { "color": "#005b96"}},
					"backColor": { "solid": { "color": "#ffffff"}},
                    "outline": "LeftOnly",
					"autoSizeColumnWidth": true,
					"fontFamily": "Calibri",
					"fontSize": 11,
					"alignment": "Left",
					"wordWrap": true
				}],
				"values": [{
					"fontColorPrimary": { "solid": { "color": "#4f4e51"}},
					"backColorPrimary": { "solid": { "color": "#afd6f2"}},
					"fontColorSecondary": { "solid": { "color": "#4f4e51"}},
					"backColorSecondary": { "solid": { "color": "#ffffff"}},
					"outline": "Frame",
					"urlIcon": true,
					"wordWrap": true,
					"fontFamily": "Calibri",
					"fontSize": 10
				}],
				"total": [{
					"totals": true,
					"fontColor": { "solid": { "color": "#005a96"}},
					"backColor": { "solid": { "color": "#ffffff"}},
					"outline": "Frame",
					"fontFamily": "Calibri",
					"fontSize": 10
				}]
			}

 

Example Data

CountrySum of Sales
Canada24887654885
France2435417228
Germany2350534082
Mexico2094935211
United States of America25029830165
0 REPLIES 0

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.