A few months ago, Power BI expanded the capabilities of Themes to include more than colors. You can now change the Format and even configure Analytics such as forecasting. In a previous post, I looked at how you can use the wildcard character (*) to universally set formatting under visualStyles. Here, I want to share the fruit of some work to catalog low-level properties on a per-visual basis. The files can act as a code reference to see the structure of each visual’s format options. They should be not treated as final Theme files like those you find in the Themes Gallery.
Before creating Themes in Power BI, it would be helpful to review the documentation on Report Themes. I had a lot of trouble and confusion with how the properties for all visuals are presented together in the documentation, so I split things out into separate visuals and also filled in some gaps. This made it easier for me to compare what I was seeing in a visual’s Format menu with what I was adding to a theme file.
–>> Get them from GitHub or view the list of individual links below: PowerBI-ThemeTemplates repository<<–
If you notice an issue, log it in the GitHub repository. Better yet, fork it, fix the problem, and submit a pull request.
Glancing at any of the JSON files, you should notice that there are properties with names that do not align with what you see in Power BI’s Format menu. Properties used in Themes are based on the code used in the visual and not the display name that users see in Power BI. Sometimes these names match but usually they do not. For example, in the screenshot above for a Shape, “Rotation” in Power BI Desktop corresponds to “angle” in the JSON.
These template files function as a quick reference for anyone who does not simply want to rely on using wildcards (*) and who may not want to dig through the report theme documentation to figure it out on their own. Remember, these are not final theme files. They are more of a reference for the structure. Many of the values are not Power BI’s defaults but are set to easily verify a format change. In other words, these settings are often intentionally ugly so that I could easily check whether something changed.
Feel free to combine visuals, omit properties you don’t need, and change the sample values to what you want. Use these templates as guides to building your own themes.
Clustered Bar Chart
Clustered Column Chart
Hundred Percent Stacked Bar Chart
Hundred Percent Stacked Column Chart
Line and Clustered Column Chart
Line and Stacked Column Chart
Stacked Area Chart
Stacked Bar Chart
Stacked Column Chart
As an Amazon Associate I earn from qualifying purchases.