Theming in Power BI


Finally, we have theming in Power BI. A much requested and required feature, especially for organizations where using their corporate color themes in everything they do, is a way of life. And even when showcasing the capabilities of Power BI to potential clients, the questions sometimes boils down to something simple things like the customization of the color theme. This question can now be attempted with a confident ‘yes’, rather than the thoughtful ‘yes’ that we blurt out while mentally going through the steps of applying a colors from widget to widget.

The March 2017 update of Power BI Desktop comes with a preview of Themes. Right now it is in its simplest of forms: You manually create a JSON file that has a very few attributes that can set basic color themes to your reports. So all you have to do is create file that looks like this:

{
“name”: “rainbow”,
“dataColors”: [ “#FF0000”, “#FF7F00”, “#FFFF00”, “#00FF00”, “#0000FF”, “#4B0082”, “#9400D3” ],
“background”:”#FFFFFF”,
“foreground”: “#9400D3”,
“tableAccent”: “#FFFF00”
}

And then do this in Power BI Desktop; here:

Theme Import

And lo and behold my rainbow theme is applied:

To revert, you just re-select the Default Theme.

Yes, it is old-school, but this is preview, and only a few attributes are designed to get affected by the theme settings. However, it works, it gives us an idea as to what’s coming, and also let’s us pour in our suggestions as well.

What I really like about this is that you can have any number of colors listed out, usually it is around 8, with Power BI adding the default white and black. And what I really like about it is the list of accent colors based on the main colors:

Theme Colors

All in all these are exciting times. Things on the aesthetic customization aspect can only get better. To read more, check out the Power BI blog.

Advertisements

2 thoughts on “Theming in Power BI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s