Forum Discussion

DineshArivu's avatar
DineshArivu
Helper I
8 months ago
Solved

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

    1. Open your Power BI Desktop report
    2. Go to View tab → ThemesBrowse for themes
    3. Select your MyTheme.json file
    4. 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

  •  

    1. Open Power BI Desktop

    2. Go to View → Themes → Browse for themes

    3. Select this JSON file

    4. 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. 

    1. Open your Report in Power BI Desktop
    2. 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 theme

    You are done. 

     

    Find this helpful give a like and accept it as a solution. 

    Thanks

6 Replies

  • 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. 

    1. Open your Report in Power BI Desktop
    2. 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 theme

    You 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

    1. Open your Power BI Desktop report
    2. Go to View tab → ThemesBrowse for themes
    3. Select your MyTheme.json file
    4. 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

  •  

    1. Open Power BI Desktop

    2. Go to View → Themes → Browse for themes

    3. Select this JSON file

    4. 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-echaithra's avatar
    v-echaithra
    Community 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.