Forum Discussion
JSON format file to standardize the new dashboards
- 8 months ago
Hi DineshArivu,
You can create a JSON theme file to standardize your dashboard formatting. Here's how:
Step 1: Create the JSON file
Create a text file named MyTheme.json with this content (adjust to your requirements):
{ "name": "Custom Theme", "dataColors": ["#4D1DA3", "#6941EB", "#FECB02", "#9D84F2", "#FED766"], "background": "#FFFFFF", "foreground": "#000000", "tableAccent": "#FECB02", "visualStyles": { "*": { "*": { "title": [{ "color": {"solid": {"color": "#6941EB"}}, "fontFamily": "Segoe UI", "fontSize": 12 }] } }, "page": { "*": { "background": [{ "color": {"solid": {"color": "#4D1DA3"}}, "transparency": 0 }] } }, "tableEx": { "*": { "grid": [{ "gridVertical": true, "gridHorizontal": true, "rowPadding": 3 }], "columnHeaders": [{ "fontColor": {"solid": {"color": "#FECB02"}}, "fontFamily": "Segoe UI Semibold" }] } } } }Step 2: Apply to Power BI
- Open your Power BI Desktop report
- Go to View tab → Themes → Browse for themes
- Select your MyTheme.json file
- The theme will apply to all visuals
Step 3: Customize further
Adjust colors in the JSON as needed. For more options, export an existing theme: View → Themes → Customize current theme → Export.
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
- 8 months ago
Open Power BI Desktop
Go to View → Themes → Browse for themes
Select this JSON file
Save the report or publish
{ "name": "DK Standard Dashboard Theme", "background": "#FFFFFF", "foreground": "#000000", "tableAccent": "#4D1DA3", "dataColors": [ "#4D1DA3", "#6941EB", "#FECB02", "#8B6FE8", "#FFD84D" ], "visualStyles": { "*": { "*": { "title": [ { "show": true, "fontColor": { "solid": { "color": "#6941EB" } }, "fontSize": 12, "fontFamily": "Segoe UI Semibold" } ] } }, "table": { "*": { "columnHeaders": [ { "fontColor": { "solid": { "color": "#FECB02" } }, "background": { "solid": { "color": "#4D1DA3" } }, "fontSize": 11 } ] } }, "matrix": { "*": { "columnHeaders": [ { "fontColor": { "solid": { "color": "#FECB02" } }, "background": { "solid": { "color": "#4D1DA3" } } } ] } }, "page": { "*": { "background": [ { "color": { "solid": { "color": "#FFFFFF" } }, "transparency": 0 } ] } } } } - 8 months ago
Hi DineshArivu,
in Power BI Desktop, you can go to view, themes, save current theme. That will export the JSON.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
- 8 months ago
Hi DineshArivu
At first you need to export the existing power bi theme that you want to use for other Power BI report.
- Open your Report in Power BI Desktop
- Go to View tab → Themes → Save Current Theme (In your computer)
Note: If save is not available click Customize current theme -> Name and Color -> Give a random name then you can save it.
Now open your new report and do these.
Go to View tab → Themes → Browse for Theme -> Select previously exported themeYou are done.
Find this helpful give a like and accept it as a solution.
Thanks
Hi DineshArivu,
You can create a JSON theme file to standardize your dashboard formatting. Here's how:
Step 1: Create the JSON file
Create a text file named MyTheme.json with this content (adjust to your requirements):
{
"name": "Custom Theme",
"dataColors": ["#4D1DA3", "#6941EB", "#FECB02", "#9D84F2", "#FED766"],
"background": "#FFFFFF",
"foreground": "#000000",
"tableAccent": "#FECB02",
"visualStyles": {
"*": {
"*": {
"title": [{
"color": {"solid": {"color": "#6941EB"}},
"fontFamily": "Segoe UI",
"fontSize": 12
}]
}
},
"page": {
"*": {
"background": [{
"color": {"solid": {"color": "#4D1DA3"}},
"transparency": 0
}]
}
},
"tableEx": {
"*": {
"grid": [{
"gridVertical": true,
"gridHorizontal": true,
"rowPadding": 3
}],
"columnHeaders": [{
"fontColor": {"solid": {"color": "#FECB02"}},
"fontFamily": "Segoe UI Semibold"
}]
}
}
}
}Step 2: Apply to Power BI
- Open your Power BI Desktop report
- Go to View tab → Themes → Browse for themes
- Select your MyTheme.json file
- The theme will apply to all visuals
Step 3: Customize further
Adjust colors in the JSON as needed. For more options, export an existing theme: View → Themes → Customize current theme → Export.
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution