How to use your Office Theme as Power BI Report Theme

[DominikPetri]

With Report Themes (preview feature in Power BI Desktop) you can apply a color theme to your entire report, such as corporate colors.

Do you already have a corporate color palette in Microsoft Office (Word, PowerPoint, Excel etc.) and want to use it Power BI Desktop? I have created an Excel File that converts the Office Theme Colors into a Power BI Desktop Theme in 4 simple steps:

1. Select the Office Theme Color in Excel from the Page Layout tab
2. The embedded VBA code will create the hex codes for the color palette
3. Name your theme
4. Preview the theme and save it (via dialog) in your preferred folder

You can download the file from my OneDrive (since it contains forms and VBA you can't run it in Excel Online):

Office Theme Converter v3 as zip file

If you have any suggestions, improvements, comments etc. please let me know 🙂

Thank you and have fun converting your existing Office Design Colors to Power BI Desktop!

Dominik Petri

[chass]

Very very nice!

[jfaubert]

Beautiful.  Worked great!

[DominikPetri]

Glad to hear @jfaubert!