Forum Discussion

ThomasCh's avatar
ThomasCh
Frequent Visitor
4 years ago
Solved

Table border color in JSON

Hello, I am trying to change the border color for tables in JSON, but I am unable to find out the code for this. The color I want to change is located under "Grid" and "Border".   This wil...
General Comment
Need Help
  • JoaoMarcelino's avatar
    JoaoMarcelino
    4 years ago

    Hi again ThomasCh ,

    One last try for the sake of our pride:

    Try adding this line of code to the "Grid" section instead of border:

    If this works, you buy me coffee later 🙂
    If it doesn't work, at least we gave our best!

    Hope I was of assistance!
    Cheers
    Joao Marcelino
    Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂

JoaoMarcelino's avatar
JoaoMarcelino
Icon for Responsive Resident rankResponsive Resident
4 years ago

Hi ThomasCh ,
How are you? 🙂

There is an amazing JSON visuals repository for Power BI, that the brilliant and kind Matt Rudy ( MattRudy (Matt Rudy) · GitHub) did and shares for free: GitHub - MattRudy/PowerBI-ThemeTemplates: JSON Templates for assembling Power BI Themes

What you probably need to do is:
Go to the  specific visual you need

And then, by keeping the same structure, add the piece of code you need, probably this:

 

I hope this helps!

Hope I was of assistance!
Cheers
Joao Marcelino
Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂
 

  • ThomasCh's avatar
    ThomasCh
    Frequent Visitor
    4 years ago

    Hello there, and thank you for your reply! 

    I know about this site, and unfortunately it doesn't look like it has been updated lately. As you can see from my attached photo, that attribute changes the border for the whole table, and not where I want it to change (that blue line should be orange).

     

    • JoaoMarcelino's avatar
      JoaoMarcelino
      Icon for Responsive Resident rankResponsive Resident
      4 years ago

      Hi again ThomasCh ,

      One last try for the sake of our pride:

      Try adding this line of code to the "Grid" section instead of border:

      If this works, you buy me coffee later 🙂
      If it doesn't work, at least we gave our best!

      Hope I was of assistance!
      Cheers
      Joao Marcelino
      Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂

      • itsmebvk's avatar
        itsmebvk
        Icon for Continued Contributor rankContinued Contributor
        3 years ago

         

        Hi JoaoMarcelino ,

         

        I am also facing similar issue. I followed the suggestion you made but not sure why it is not working in my case. Still I am unable to invoke left and right border to the grid. If possible can you please correct my mistake.

         

         

         

        {
	"name": "TableTemplate",
	"visualStyles": {
		"tableEx": {
			"*": {
				"grid": [{
					"gridVertical": true,
					"gridVerticalColor": { "solid": { "color": "#D3D3D3"}},
					"gridVerticalWeight": 1,
					"gridHorizontal": true,
					"gridHorizontalColor": { "solid": { "color": "#D3D3D3"}},
					"gridHorizontalWeight": 1,
					"gridBorder": true,
					"gridBorderColor": { "solid": { "color": "#D3D3D3"}},
					"gridBorderWeight": 1,
					"rowPadding": 5,
					"outlineColor": { "solid": { "color": "#D3D3D3"}},
					"outlineWeight": 1,
					"textSize": 8,
					"imageHeight": 100
				}],
				"columnHeaders": [{
					"fontColor": { "solid": { "color": "#FFFFFF"}},
					"backColor": { "solid": { "color": "#808080"}},
					"outline": "Frame",
					"autoSizeColumnWidth": true,
					"fontFamily": "Segoe UI",
					"fontSize": 8,
					"alignment": "Center",
					"wordWrap": true,
					"bold": true
					
				}],
				"values": [{
					"fontColorPrimary": { "solid": { "color": "#252423"}},
					"backColorPrimary": { "solid": { "color": "#FFFFFF"}},
					"fontColorSecondary": { "solid": { "color": "#252423"}},
					"backColorSecondary": { "solid": { "color": "#FFFFFF"}},
					"outline": "Frame",
					"urlIcon": true,
					"wordWrap": true,
					"fontFamily": "Segoe UI",
					"fontSize": 8
				}],
				"total": [{
					"totals": true,
					"fontColor": { "solid": { "color": "#FFFFFF"}},
					"backColor": { "solid": { "color": "#808080"}},
					"outline": "Frame",
					"fontFamily": "Segoe UI",
					"fontSize": 8,
					"bold": true
				}],
				"stylePreset": [{ 
					"name": "BoldHeader"
				}],
				"border":[{
					"show" :true ,
					"color": { "solid": { "color": "#808080"}},
					"radius": 0
				}],
				"title": [{
					"show": true,
					"text":  "Enter Title Using Title Property",
					"alignment": "center",
					"fontColor": { "solid": { "color": "#FFFFFF" } },
					"background": { "solid": { "color": "#808080" } },
					"fontSize": 13,
					"fontFamily": "Calibri",
					"bold": true
				}]
			}
		}
	}
}

         

        Thanks in advance.