If you are creating themes for your Power BI reports, you already know it can be challenging as there is not a lot of information describing how the JSON file theme should be built.
The bundle contains two products:
- The JSON Theme Guide for Power BI by Curbal: A report that contains 6 tabs (one is hidden) to not only help you create your theme files easier, but also to use it as a guideline for your theme in your organization and
- The complete JSON Theme: Curbal’s JSON file that contains almost* all of the properties available at the moment of publishing it that you can use to create your own JSON file faster.
*NOTE: There are around 2% of the properties (60 out of 2.474) that either they are not available yet, not possible to configure using the JSON file or I just couldn’t figure them out. Those properties are marked with “?” in the file.
** This purchase gives you access to download all new revisions for a year from the date of purchase.
Contents for the JSON Theme Guide:
Here is a video that explains everything, but if you prefer to read, skip it and scroll to the text:
The following elements can be found in the report.:
- The Welcome Page, is your home page with links to all the resources available in the report. Just click on the images to go to different tabs and start customizing your theme.
- The Labels Page, will allow you to search for Power BI visuals to find what labels are available for them. The labels are displayed in the same order as they appear in Power BI. Once you find the label you are looking for , right-click to go to the Properties Page, where all properties and values are listed.
- The Properties Page, is hidden as it is used as a drillthrough for the Labels Page. Here you can see the name of the properties in the JSON file and the type you use for them. Once you are done, click the back arrow to go back to the Labels Page.
- The Bulk Page, will allow you to search for visuals, labels or properties without having to go to the Label Pages. It can also list all the visuals that have a specific property if you want to do bulk editing.
- The Font Page, will show the JSON name for the fonts and show you the default fonts for the Curbal theme.
- and finally, the Color Page, will list all the colors available for this theme and give you their HEX code as well as some best practices.
And the following fields are available for you, so you can start modifying your JSON file:
- PBI Visual Order: Sorts the visuals in the same order they are placed on Power BI Desktop
- PBI Visual: Name of the Power BI visual
- JSON Visual: Name of the Power BI visual in the JSON file
- PBI Label Order: Sorts the labels in the same order they are placed on Power BI Desktop
- PBI Label: Name of the Power BI label
- JSON Label: Name of the Power BI label in the JSON file
- PBI Property Order: Sorts the properties in the same order they are placed on Power BI Desktop
- PBI Property: Name of the Power BI property
- JSON Property: Name of the Power BI property in the JSON file
- Description: Short description of what this property sets in Power BI Desktop
- PBI Value: Explains if the property is a text, number, color, etc and shows the dropdown options available for each property.
- JSON Value: Explains if the property is a text, number, color, etc and shows the dropdown options available for each property and the JSON name for each option.
- 2,474 rows with properties,
- 29 visuals,
- 156 (distinct) properties and
- 76 (distinct) labels
This is a snapshot of what you will get.
Contents for the JSON file:
The JSON file contains all available and known properties needed to customize your Power BI file with your own theme, including:
- 29 visuals,
- 156 properties and
- 76 labels
Screenshot of the JSON file:
- The JSON file included in the Power BI report is the default one with some modifications.
- The properties specified on the report are in the same order as you will find in Power BI Desktop (at the time this was published).
- If the property is not active it will have an underscore at the end of the name: “fontSize_”. To make the property available, just remove the underscore.
- Keep in mind that some properties are set globally. Locally set properties normally override global properties.
- If you find a question mark on a property, it means that it is either not available yet, not possible or I just couldn’t figure it out.
- The JSON file contains the colors, font and branding theme for Curbal. Feel free to use it in your reports if you like it.