JSON format file to standardize the new dashboards

[DineshArivu]

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

[Mauro89 · Accepted solution]

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 → Themes → Browse 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

[cengizhanarslan · Accepted 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
          }
        ]
      }
    }
  }
}

[tayloramy · Accepted solution]

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.

[v-echaithra]

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.

[v-echaithra]

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.

[Royel · Accepted 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

[tayloramy · Accepted solution]

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.

[cengizhanarslan · Accepted 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
          }
        ]
      }
    }
  }
}

[Mauro89 · Accepted solution]

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 → Themes → Browse 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