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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
saranicole2695
Frequent Visitor

Theme JSON: Card

Hi! I am in the process of building a customized them with JSON. I have gotten everything but my Card formatting section to work. I have spent the last couple hours scouring through google, youTube, and Power BI Community to no avail. I find a lot of information but very little in relation to the Card visual.  I want to set the formatting of the Data Label, Title, and Border. Below is the card section of my JSON code. None of these peices affect the visuals. Any assistance would be greatly appreciated.  Thanks!

 

"visualStyles":{  
      "card":{  
         "*":{  
        	
			"labels": [{
				"color": { "solid": { "color": "#000000" } },
				"labelDisplayUnits": 1,
				"LabelPrecision": "0",
				"fontSize": 27,
				"fontFamily": "DIN"
				
			}],
			
			 "border": [{
				    "show": true,
				    "color": { "solid": { "color": "#30770F"}}, 
					"radius": 15
                
            }],
				
			"categoryLabels": [{
				"show" : false
			}],
			
			 "title": [{
				    "show": true,
				    "fontColor": { "solid": { "color": "#000000" } },
				    "background": { "solid": { "color": "#FFFFFF" } },
				    "alignment": "center",
				    "fontSize": 15,
				    "fontFamily": "Segoe UI"
				  }]
			
         }
      }
   },
1 ACCEPTED SOLUTION

Hi saranicole2695,

It seems that the "visualStyle" is duplicated in your sample, I will check your sample in my environment. In addition, you could refer to Report Theme Generator V3 , then set attribute vaue in it, then you could get json file when you click "Download".

461.PNG

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

8 REPLIES 8
trebgatte
Most Valuable Professional
Most Valuable Professional

Have you looked at David's repo on this? https://github.com/deldersveld/PowerBI-ThemeTemplates/blob/master/Card.json

 

Thanks!

--Treb

 

Check out my Power BI blog posts at: https://marqueeinsights.com/tag/power-bi/

Yes. That is where I got the code that I used from. I can copy exactly what he has there and paste it in and it still has no affect on a card in my file. It doesn't affect existing cards or any added after the theme is applied.

Hi saranicole2696,

I test this in my environment(July 2019 desktop), I get below result when I import json by click switch theme->import theme

{
	"name": "CardTemplate",
	"visualStyles": {
		"card": {
			"*": {
				"labels": [{
					"color": { "solid": { "color": "#000000"}},
					"labelDisplayUnits": "1",
					"labelPrecision": 0,
					"fontSize": 27,
					"fontFamily": "DIN"
				}],
					
			"categoryLabels": [{
				"show" : false
			}],
				"wordWrap": [{
					"show": true
				}],
				
				   "title": [{
				    "show": true,
				    "fontColor": { "solid": { "color": "#000000" } },
				    "background": { "solid": { "color": "#FFFFFF" } },
				    "alignment": "center",
				    "fontSize": 15,
				    "fontFamily": "Segoe UI"
				  }],
				   "border": [{
				    "show": true,
				    "color": { "solid": { "color": "#30770F"}}, 
					"radius": 15
                
            }]
			}
		}
	}
}

459.PNG

So what is your desktop version? If you close the desktop and re-open, re-import theme, will this work ?

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Well, that is what it is supposed to look like.  I am on the newest version (October 2019). I have closed and reopened desktop and still nothing. Could it be a bug in the newest version? Is there a way to get a previous version back?

trebgatte
Most Valuable Professional
Most Valuable Professional

Bear in mind, that card JSON is a snippet that has to be inserted into the overall JSON structure. You can see that here: https://docs.microsoft.com/en-us/power-bi/desktop-report-themes#report-theme-json-file-format

 

This is why we wind up building these for our clients as the complexity is subtle. 

 

Hope this helps.

--Treb

 

Check out my Power BI blog posts at https://marqueeinsights.com/category/power-bi/

Right, that is just the card portion of the entire file. All of the other visual types that have have specs laid out for are working perfectly.  Here is the entirety of the code.

 

{

"name": "CGB",

"dataColors": [ "#839A43", "#945D5D", "#DFB84C", "#4F80B8", "#631A42", "#8D8D8D", "#46639E", "#99ACC4", "#FFBC00" ],

"background":"#FFFFFF",

"foreground": "#000000",

"tableAccent":"#30770F",

"visualStyles":{  
    "clusteredColumnChart":{
		"*" :{
			"title": [{
				    "show": true,
				    "fontColor": { "solid": { "color": "#000000" } },
				    "background": { "solid": { "color": "#FFFFFF" } },
				    "alignment": "center",
				    "fontSize": 15,
				    "fontFamily": "Segoe UI"
				  }]
				}
			}
		},

"visualStyles":{
	"card":{  
         "*":{  
        	
			"labels": [{
				"labelDisplayUnits": "1",
				"LabelPrecision": 0,
				"fontSize": 27,
				"fontFamily": "DIN"
				
			}],
			
			 "border": [{
				    "show": true,
				    "color": { "solid": { "color": "#30770F"}}, 
					"radius": 15
                
            }],
				
			"categoryLabels": [{
				"show" : false
			}],
			
			 "title": [{
				    "show": true,
				    "fontColor": { "solid": { "color": "#000000" } },
				    "background": { "solid": { "color": "#FFFFFF" } },
				    "alignment": "center",
				    "fontSize": 15,
				    "fontFamily": "Segoe UI"
				  }]
		     }
         }
      },
   

"visualStyles":{  
      "pieChart":{  
         "*":{  
          
            "border": [{
				    "show": true,
				    "color": { "solid": { "color": "#30770F"}}, 
					"radius": 15
			}],
					
            "title": [{
				    "show": true,
				    "fontColor": { "solid": { "color": "#000000" } },
				    "background": { "solid": { "color": "#FFFFFF" } },
				    "alignment": "center",
				    "fontSize": 15,
				    "fontFamily": "Segoe UI"
				  }], 
			"legend": [{
				"show": false
			}],
			
			"labels": [{
					"show": true,
					"labelStyle": "Data",
					"color": { "solid": { "color": "#000000" } },
					"labelDisplayUnits": 1,
				    "LabelPrecision": "0",
				    "fontSize": 15,
				    "fontFamily": "Segoe UI",
					"position": "Outside"
			}]
           
         }
      }
   }	
}

Hi saranicole2695,

It seems that the "visualStyle" is duplicated in your sample, I will check your sample in my environment. In addition, you could refer to Report Theme Generator V3 , then set attribute vaue in it, then you could get json file when you click "Download".

461.PNG

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Thanks for all of the feedback. I am so much closer.  All of the Card specs are now populating in Power BI when I import the JSON except for labelPrecision. Any ideas on that? I have tried all kinds of things to get it to pull something in. I have tried just using a 0 and "0". Verified the command. Tried a different one: dataLableDecimalPlaces. Tried other numbers 1, 2, 5. Nothing has seemed to work.  Any ideas?

 

Capture.PNG

 
 
	"card":{  
         "*":{  
        	
			"labels": [{
				"color": { "solid": { "color": "#000000"}}, 
				"labelDisplayUnits": 1,
				"LabelPrecision": "0",
				"fontSize": "25",
				"fontFamily": "Trebuchet MS"
				
			}],
			
			 "border": [{
				    "show": true,
				    "color": { "solid": { "color": "#30770F"}}, 
					"radius": 15
                
            }],
				
			"categoryLabels": [{
				"show" : false
			}],
			
			 "title": [{
				    "show": true,
				    "fontColor": { "solid": { "color": "#000000" } },
				    "background": { "solid": { "color": "#FFFFFF" } },
				    "alignment": "center",
				    "fontSize": 15,
				    "fontFamily": "Segoe UI"
				  }]
		     }
      },

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.