JSON Theme Guide for Power BI by Curbal 2023

Description

What is included in the purchase?

When you purchase the template app, you will receive the complete pbix or Power BI file with the Power Query, Model, DAX calculations and visualizations as well as background images.

My company has disabled template apps, where can I test the app?

No problem, you can try it here:

I purchased the template app, where do I find the download link?

Once you purchased the template app, you will receive an email with the download link.

If you didnt receive it or you want to download it again, follow this steps to find the download link in your Curbal Acccount:

1. Log in your curbal account:

2. Click on Register/Login again, My account and Downloads, and you will find your downloads there:

Report Contents

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 following report 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.

You have also available for purchase the complete* JSON file used in this report here or you might prefer to get both in this bundle here.

*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

Here is a video explaining everything, but if you prefer text, just continue reading:

The following elements can be found in the report.:

1. 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.
2. 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.
3. 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.
4. 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.
5. The Font Page, will show the JSON name for the fonts and show you the default fonts for the Curbal theme.
6. 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.

and the Power BI file contains:

1. 4988 rows with properties,
2. 37 visuals,
3. 4899 rows,
4. 177 (distinct) properties and
5. 60 (distinct) labels

This is a snapshot of what you will get.

Comments

1. The JSON file included in the Power BI report is the default one with some modifications.
2. 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).
3. Keep in mind that some properties are set globally. Locally set properties normally override global properties.
4. 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.