Forum Discussion
JSON format file to standardize the new dashboards
Hi Experts,
how to use existing power bi dashboard theme as a JSON format file to standardize the new dashboards?
My existing dashboard theme :
header - #4D1DA3
All visual title - #6941EB
Table columns title - #FECB02
how to generate a jSON file with this theme and use the same to an another dashboard ?
Thanks
DK
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
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 } ] } } } }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.
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
6 Replies
- tayloramySuper User
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.
- RoyelSuper User
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
- Mauro89Super User
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
- cengizhanarslanSuper User
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 } ] } } } } - v-echaithraCommunity Support
Hi DineshArivu ,
Thank you Royel , tayloramy , cengizhanarslan , Mauro89 for your inputs.I just wanted to check if the issue has been resolved on your end, or if you require any further assistance. Please feel free to let us know, we’re happy to help!
Thank you
Chaithra E. - v-echaithraCommunity Support
Hi DineshArivu ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.