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

Curbal

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

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • 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 on the September 2017 update of Power BI Desktop, they allow us to define even more elements and that is great, but the documentation is poor (sorry Microsoft, it is) 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 sharing it with all of you so you dont have to waste a lot of time finding out how to build it.

This is an iterative process and I am still working with the file, but it is useful, even if it has a few bugs and some missing fields.

Video tutorial on how to create a JSON file

Watch this video if you need help getting started with the creation of a JSON file.

Video tutorial on how to use Curbal’s JSON template

Watch this video if you need help getting started with the file. I will do a tutorial on the JSON file in a later video.

Link to JSON file

And you also get my work-in-progress Power BI JSON template (It is saved as a TXT, just change the extension):

Curbal_PowerBI_theme

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

/Ruth

Filed Under: Microsoft Power BI

Join our community of over 11,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

Let us know your thoughts... Cancel reply

Primary Sidebar

Search Website:

Subscribe to our YouTube Channel!

Apply for Membership (+12,500 members)

Become a Member

Awards: MVP Data Platform

MVP Data Platform Ruth Pozuelo Martinez
Microsoft MVP Profile Page

About Ruth:

Speaking gigs:

Footer CTA

Join our community of +12,500 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 6
722 13 – Västerås
Sweden

OrgNo:5569680852 | VAT:SE556968085201

 

Location:

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