• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / Microsoft Power BI / Power BI Template to create Report Themes with the JSON template
Power BI Template to create Report Themes with the JSON template

Power BI Template to create Report Themes with the JSON template

posted on November 15, 2017

You can customize the look and feel of the Power BI reports using the formatting pane for each specific visual or you can speed up the process by using a JSON file.

This feature (the JSON file) has been available for quite a while but the documentation is poor  and unfortunately, a lot of the elements wont work even when you add them correctly to the file.

To be able to manage this, I have created my own guide for the JSON file and I am making it available for you to purchase, as well as my complete JSON file:

  • JSON Theme Bundle (Guide +JSON) for Power BI by Curbal 2025
    JSON Theme Bundle (Guide +JSON) for Power BI by Curbal 2025
    449 € (Price excl. VAT: 359 €)
    Add to cart
  • Complete JSON Theme for Power BI by Curbal 2025
    Complete JSON Theme for Power BI by Curbal 2025
    299 € (Price excl. VAT: 239 €)
    Add to cart
  • JSON Theme Guide for Power BI by Curbal 2024
    JSON Theme Guide for Power BI by Curbal 2024
    299 € (Price excl. VAT: 239 €)
    Add to cart

User Guide to the JSON Guide Template

Here is a video explaining everything, but if you prefer to read, skip the video and scroll to the text:

JSON Theme Guide and file for Power BI by Curbal

I have created a Power BI report that contains the following:

  1. A Welcome Page, or in other words, 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. A 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. A 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. A 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. A 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. 2,474 rows with properties,
  2. 29 visuals,
  3. 156 (distinct) properties and
  4. 76 (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.

User guide to the JSON file

If you purchase this product you will get Curbal’s JSON file that contains almost* all of the properties available at the moment of publishing it.

You have also available for purchase the JSON Theme Guide that will explain all the properties used in this file 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.

Contents

The JSON file contains all available and known properties needed to customize your Power BI file with your own theme, including:

  1. 29 visuals,
  2. 156 properties and
  3. 76 labels

Screenshot of the JSON file:

Comments

  1. The JSON file contains the colors, font and branding theme for Curbal. Feel free to use it in your reports if you like it.
  2. The properties specified on the JSON file are in the same order as you will find in Power BI Desktop (at the time this was published).
  3. 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.
  4. Keep in mind that some properties are set globally. Locally set properties normally override global properties.
  5. 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.

Purchase the guide and JSON file

If you want to customize the guide and JSON file, they are available for you to purchase here:

  • Google analytics 4 template for Power BI
    Google Analytics 4 Template App by Curbal
    449 € (Price excl. VAT: 359 €)
    Add to cart
  • JSON Theme Bundle (Guide +JSON) for Power BI by Curbal 2025
    JSON Theme Bundle (Guide +JSON) for Power BI by Curbal 2025
    449 € (Price excl. VAT: 359 €)
    Add to cart
  • Complete JSON Theme for Power BI by Curbal 2025
    Complete JSON Theme for Power BI by Curbal 2025
    299 € (Price excl. VAT: 239 €)
    Add to cart
  • JSON Theme Guide for Power BI by Curbal 2024
    JSON Theme Guide for Power BI by Curbal 2024
    299 € (Price excl. VAT: 239 €)
    Add to cart

Hopefully you will find this template as useful as I have and it gets you started creating Power BI templates in no time 

Release Notes

Release DateVersionNotes
2019-12-XXv6Not released yet

Filed Under: Microsoft Power BI

Join our community of over 50,000 professionals

Become a Member

Subscribe to YouTube

Reader Interactions

Comments

  1. Ad

    June 19, 2019 at 2:18 am

    has anyone had any success getting the alternate row color to work on a matrix been trying “pivotTable”:{“backColorSecondary”: { “solid”: { “color”: “#4E008E” } }
    }
    but no success

    Reply
    • Ruth Pozuelo Martinez

      June 19, 2019 at 7:58 am

      Hi Adam,
      Download my Json file in the membership downloads at the download center. It is working on my file.
      I am on my mobile, so I can’t check it right now.
      /Ruth

      Reply
  2. Tom M.

    January 24, 2019 at 10:16 pm

    Per this help topic page backgrounds, visual titles, and visual backgrounds are now editable in JSON:

    https://community.powerbi.com/t5/Desktop/Using-Theme-to-set-Title-Background-amp-Font-Color/td-p/268222

    Reply
    • Ruth Pozuelo Martinez

      January 25, 2019 at 12:09 pm

      Thanks for sharing!!
      A video update is on the way 🙂
      /Ruth

      Reply
  3. MikeK

    August 17, 2018 at 2:25 pm

    your tool is very helpfull, but i have an issue with the pivot – popertyname .
    How can i acces the last headerfield and set a different Background Color.
    I try it but how can i switch the Combobox to the last entry? Is this possible?

    “pivotTable”: {
    “*”: {
    …
    }
    ],
    “columnFormatting”: [
    {
    “backColor”: { “solid”: { “color”: “#333333” } }
    }
    ]
    }
    ….

    Thanks, Mike

    Reply
    • Ruth Pozuelo Martinez

      August 23, 2018 at 12:51 pm

      Hi Mike,
      It wasn’t possible before, but it might be now with the august update. I need to check…
      I will do a video on it when I get there :)/Ruth

      Reply
« Older Comments

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Search Website:

Subscribe to our YouTube Channel (+130k subs)!

Apply for Membership (+50,000 members)

Become a Member

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In