Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Yash
New Member

Custom themes

Hello,

 

Will Power BI support custom themese in future?

 

Thanks,

Yash

 

2 ACCEPTED SOLUTIONS
regbac
Regular Visitor

Hi. It is not possible yet. But a certain of the designer was shown at ignite that had customized themes. So I guess we just need to keep waiting a little longer.
Cheers
Régis

View solution in original post

WillT
Community Admin
Community Admin

27 REPLIES 27
danno
Resolver V
Resolver V

I am still having issues with using the JSON file for Themes in Power BI, some of the sections of the file do not work.  I am simply trying to apply a theme which has a white background on the visuals and a light grey background on the page.  the page visual is loaded as an image and the Border and Background should be controlled by the theme file.  I have tried following advice from here: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/How-to-create-a-Power-BI-theme-with-a-JS... but again some of the information on card names is incorrect.   The documentation here doesn't give you all you need with working samples: https://docs.microsoft.com/en-us/power-bi/desktop-report-themes.  

 

Here is the theme file contents.  can you please help? 

 

 {
  "name": "Theme v1",
  "background": "#ffffff",
  "foreground": "#0C3370",
  "tableAccent": "#144496",
  "dataColors": [
    "#0C3370",
    "#144496",
    "#5D74B2",
    "#8BA5D6",
    "#B5CDE5",
    "#D2DFED",
    "#E9EFFC",
    "#071937"
  ],
  "visualStyles": {
    "*": {
      "*": {
        "*": [
          {
            "fontSize": 9,
            "fontFamily": "Segoe UI Light"
          }
        ],
        "Comment": "this section modifies properties of all visuals which correspond with the property in quotes",
        "title": [
          {
            "show": true,
            "fontColor": {
              "solid": {
                "color": "#000000"
              }
            },
            "background": {
              "solid": {
                "color": "#FFFFFF"
              }
            },
            "alignment": "left",
            "fontSize": 11,
            "fontFamily": "Segoe UI Light"
          }
        ]
      }
    },
    "Comment": "this section modifies settings for the Tables",
    "tableEx": {
      "*": {
        "grid": [
          {"gridVertical":false,
    "gridHorizontal":false,
            "textSize": 9
          }
        ],
 "values": [
 {"bandedRowHeaders" : "false",
 "backColorPrimary" : {
              "solid": {
                "color": "#FFFFFF"
              }
            },
 "backColorSecondary" : {
              "solid": {
                "color": "#FFFFFF"
              }
            }
 }
 ],
        "columnHeaders": [
          {
            "fontFamily": "Segoe UI",
            "fontSize": 9,
            "color": {
              "solid": {
                "color": "#0C3370"
              }
            },
            "outline": "TopBottom"
          }
        ],
        "background": [
          {
            "show": true,
            "color": {
              "solid": {
                "color": "#FFFFFF"
              }
            },
            "transparency": 0
          }
        ],
        "border": [
          {
            "show": true,
            "color": {
              "solid": {
                "color": "#D1DBEE"
              }
            }
          }
        ]
      }
    },
    "Comment": "this section modifies settings for the Pivot Tables / Matrix",
    "pivotTable": {
      "*": {
        "grid": [
          {"gridVertical":false,
    "gridHorizontal":false,
            "textSize": 9
          }
        ],
 "values": [
 {"bandedRowHeaders" : false,
 "backColorPrimary" : {
              "solid": {
                "color": "#FFFFFF"
              }
            },
 "backColorSecondary" : {
              "solid": {
                "color": "#FFFFFF"
              }
            }
 }
 ],
        "columnHeaders": [
          {
            "outline": "TopBottom",
            "autoSizeColumnWidth" : false,
            "fontFamily": "Segoe UI",
            "fontSize": 9,
            "color": {
              "solid": {
                "color": "#0C3370"
              }
            }
          }
        ],
        "background": [
          {
            "show": true,
            "color": {
              "solid": {
                "color": "#FFFFFF"
              }
            },
            "transparency": 0
          }
        ],
        "border": [
          {
            "show": true,
            "color": {
              "solid": {
                "color": "#D1DBEE"
              }
            }
          }
        ]
      }
    },
    "Comment": "this section modifies settings for the Line Charts",
    "lineChart": {
      "*": {
        "background": [
          {
            "show": true,
            "color": {
              "solid": {
                "color": "#FFFFFF"
              }
            },
            "transparency": 0
          }
        ],
        "border": [
          {
            "show": true,
            "color": {
              "solid": {
                "color": "#D1DBEE"
              }
            }
          }
        ]
      }
    },
    "Comment": "this section modifies settings for the Column Charts",
    "columnChart": {
      "*": {
        "Background": [
          {
            "show": true,
            "color": {
              "solid": {
                "color": "#FFFFFF"
              }
            },
            "transparency": 0
          }
        ],
        "border": [
          {
            "show": true,
            "color": {
              "solid": {
                "color": "#D1DBEE"
              }
            }
          }
        ]
      }
    }
  }
}

 

Anonymous
Not applicable

Try this link to get help on custom visualizations / themes! https://github.com/deldersveld/PowerBI-ThemeTemplates/find/master

 

This helped me A TON.

Petersen_31
Regular Visitor

Can any explain why I keep getting this message with trying to upload a .json theme file? Error importing theme file - There was a problem importing your theme file. Please try again or choose another file.
reddobe
Regular Visitor

I keep getting an error when trying to bring in the Json file for the custom theme. I am using the St. Patricks Day file as a template and modifying the Hex codes to correspond with my companies colors.

 

{
    "name": "XYZxyz",
    "dataColors": ["#1E345D", "#768591", "#F38A00", "#99CAEA", "#DADFE1",
    "background":"#FFFFFF",
    "foreground": "#768591",
    "tableAccent": "#1E345D"
}

 

Thanks, Steve

Anonymous
Not applicable

@reddobe, you are missing a  square bracket after "#DADFE1".  Try this.

 

{
    "name": "XYZxyz",
    "dataColors": ["#1E345D", "#768591", "#F38A00", "#99CAEA", "#DADFE1"],
    "background":"#FFFFFF",
    "foreground": "#768591",
    "tableAccent": "#1E345D"
}

 

Anonymous
Not applicable

Am I missing something - after the update I don't see the Theme section on the ribbon?

Anonymous
Not applicable

Never mind - I found it in Options

noggerwood
Regular Visitor

The custom themes preview feature is fantastic, really speeds up the workflow when developing reports in Power BI.

 

Do you have a list of all the attributes that can be customised using a theme? Or is this currently the full list...

"dataColors", "background","foreground" & "tableAccent"?

DimitriNoyen
Frequent Visitor

The custom theme preview feature is great. Is it possible to specify a report background, please? Thanks you

@DimitriNoyen Not quite yet, but we have plans to add that into the theme as well!

That is certainly reassuring!  That said, and with "monthly" updates, we sure could use guidance as to "how to best prepare" for "colored" backgrounds so that we don't have to start over when the "full themes" functionality rolls out.

 

Themes are, without a doubt, a huge customer requirement and a competitive "disadvantage"!

 

We read about a "Themes/Customer Gallery" and that would be an enormous benefit - please make this ASAP!

 

Would it be possible to "provide us some roadmap guidance"?

You should see the public themes gallery release next week! When we update the theme definition to include background, you won't have to recreate your theme files, it will be additive. All the previous themes you had should still be valid, and you can just add extra stuff to it now to do more.

Hi Amanda,

 

It is now April 10, 2017, so could you provide as estimated timeline of when "Power BI Service" with Dashboards composed of "pinned tiles" may allow "themes including background colors".

 

And, for that matter as well, approx when we might see "Background color theming in Power BI Desktop" to compliment the EXCELLENT "Theming preview" in the March release.

 

Unfortunately, we like many others are "MIS-using" PIN live "Power BI Desktop reports to Dashboards" to artificially overcome the fact that "currently" pinned tiles to create dashboards DO NOT yet allow "theming".  This is not great for both us and our customers as it can be a lot of work to "REDO" a lot of work!

 

I believe the the Power BI service is "updated" more like weekly vs. the Power BI Desktop app is "monthly".  Unfortunately, while there are many exciting new cpabilities with the PBI Desktop April release last week, we see no mention of any further enhancements to the "PREVIEW Themes" from March?

 

COLOR THEMES are just so "inherently prevalent" in nearly everything we do these days - from web page design to advertising and branding to even Woindows 10 THEMES - that "it's really important" to get this functioanlity in Power BI as soon as possible !

Hello, I'm still using the trial version of Power BI, but unable to see any way to set default colors for charts, or to apply custom themes / templates. Is the feature not available with the trial version? Thanks!

Any plans to add customs color themes to Power BI Service? 

Having Custom (Color) Themes available in the Web Service version is important.

 

More so, WHY would functionality like this be available in the Desktop version, but not the Web Service version?

Same thing with changing field formats (available in Desktop but not Web).

Great, looking forward to a Gallery of themes to choose from.  I've been searching high and low to find it.  

Hey @xxcorpxx we just announced the gallery! Here's the link the the gallery and the blog post announcing it. I'll be updating the March Desktop release blog post as well with this announcement.

Congradulations Amanda and the Power BI Team!!!  Unfortunately, the "link to the gallery" - both in your community post above and in your blog post near the top of the post - doesn't yet seem to work as I am getting an "red access denied error" after I log-in to the community.

 

Anyone else get it to work?

@anywhereanytime if you try again it should work now! We had an issue where a segment of community users couldn't access it. The bug is fixed now and everything should work. Let me know if it still doesn't for you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.