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 - #6941E...
  • Mauro89's avatar
    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

    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

  • cengizhanarslan's avatar
    8 months ago

     

    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's avatar
    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.

     

  • Royel's avatar
    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. 

    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