564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
|Two easy ways to create themes in Power BI without needing to write JSON|
|This blog show two ways in which you can create custom themes in Power BI without needing to learn how to write JSON: either use the built-in theme editor in Power BI, or use the theme generator from Power BI Tiips.|
Previous versions of Power BI required you to jump through several hoops to create custom themes for reports, often going so far as to create and edit JSON files:
Looks like witchcraft to me!
Thankfully those dark times are for the most part behind us, and there are now two much easier ways to create themes. Consider this example:
Say you wanted to change the background colours, default colour palette and font sizes for this report.
There are two ways you can proceed: use Power BI's built in editor, or use the Theme Generator from Power BI tips.
The built-in themes can be edited, but they aren't as flexible as using a JSON file focused on more general settings. To use a theme, from the Power BI ribbon's View tab choose the dropdown to the right of the preview themes:
Choose from a series of built-in themes including colour-blind safe ones. These will change your font size, colour palettes and backgrounds.
If none of these take your fancy, click on Theme gallery to launch in a browser a list of hundreds of premade themes:
Beware: some of these aren't free JSON downloads, but are instead adverts for consultancy companies!
Once you have chosen a starting point (or left your theme as the default one) click on Customize current theme:
From here change the colour palette using the wheel, hex codes or even RGB!
The rest of the tabs allow basic colour, font size and border settings to be changed (although these are changed for all visuals and can't be specified for each type):
The default font size is far too small, but changing general settings will make some settings like labels too big. Use with care!
The last two settings control the background (and wallpaper) colours, plus the filter pane colours. When finished save the changes and view your created master piece:
Wow! You can save themes as part of a Power BI Template for easy reuse.
For much greater flexibility create a JSON file allowing you to control the different settings. Thankfully there is an awesome tool created by PowerBI.tips that does this for you!
Add palette colours by using the wheel, or by entering a comma-separated list of Hex codes.
The real power is the number of setting that can be changed compared to the built-in system. To change properties for all visuals click on the * icon:
Just one section of settings has more options than the entire built-in theme generator.
Then change each individual setting of each visual by selecting it from the list below.
Once a setting has changed it will be highlighted in blue.
Note that custom visuals can be changed, but this must be done manually in the JSON file.
When you've edited to your heart's content, click on the DOWNLOAD THEME button to create the JSON file.
The only downside is not being able to load in a theme for editing.
In Power BI select Browse for themes from the themes drop down under the View tab:
Select the Browse for themes option to look for themes you've created.
Find the theme you've created:
Any JSON file generated can be edited on website like this one.
Once you've imported your theme your palettes, font sizes and backgrounds will all be updated.
Once you've created a theme, share it with your colleagues either via Power BI templates or just as a JSON file.
The only things that have to be done manually are setting custom visuals, updating existing files and uploading custom fonts. For instructions on the latter check out this video by Guy in a cube.
25 Aytoun Street