Reply
Highlighted
Regular Visitor
Posts: 27
Registered: ‎11-19-2015

How to use your Office Theme as Power BI Report Theme

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

 

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

 

Member
Posts: 57
Registered: ‎11-12-2015

Re: How to use your Office Theme as Power BI Report Theme

Hey Dominik,

 

I really like your idea and think it's very useful. Thanks a lot. 

 

Regards,

Lars

Power BI Admin
Posts: 125
Registered: ‎03-22-2016

Re: How to use your Office Theme as Power BI Report Theme

Very very nice!

 

Frequent Visitor
Posts: 3
Registered: ‎05-29-2017

Re: How to use your Office Theme as Power BI Report Theme

When I tried to download the excel file from OneDrive I got the following message:

"Features that we can't show in the browser and interactive reports will be removed from the downloaded copy."

After I downloaded the Excel file I had to insert the "Generate Hex-Codes for Color" and the "Save as JSON" buttons, and assign the corresponding macros.

I have Excel 2013 and because Textjoin is a new Excel 2016 function I had to replace the third line of the formulas on row 25 with: 

CHAR(34) & "dataColors" & CHAR(34) & ": [ " & Accent_1 &","& Accent_2 &","& Accent_3 &","& Accent_4 &","& Accent_5 &","& Accent_6 &","& Hyperlink &","& Followed_Hyperlink & " ]," & CHAR(10) &

After that, everyting worked fine. Thanks!!!!

Frequent Visitor
Posts: 3
Registered: ‎05-29-2017

Re: How to use your Office Theme as Power BI Report Theme

When I tried to download the Excel file from OneDrive I got the following message:

"Features that we can't show in the browser and interactive reports will be removed from the downloaded copy."

After I downloaded the file I had to insert the "Generate Hex-Codes for Colors" and "Save as JSON" buttons and assign the corresponding macros.

Because I use Excel 2013 and Textjoin is a new Excel 2016 formula I had to replace the third line of the formula on row 25 with:

CHAR(34) & "dataColors" & CHAR(34) & ": [ " & Accent_1 &","& Accent_2 &","& Accent_3 &","& Accent_4 &","& Accent_5 &","& Accent_6 &","& Hyperlink &","& Followed_Hyperlink & " ]," & CHAR(10) &

After that everything worked fine. Thanks!!!!

Regular Visitor
Posts: 27
Registered: ‎11-19-2015

Re: How to use your Office Theme as Power BI Report Theme

Hi @dcanalesg,

 

Glad that you like it. If you download the file to YOUR OneDrive first, the buttons should be there.

 

Nevertheless, thanks for posting your solution and your formula for those who use Excel 2013 (or Excel 2016 without Office 365) and therefore don't have TEXTJOIN.

 

I will (hopefully) soon finish a blog post with an alternate download link....and a version without TEXTJOIN :-)

As soon as the blog post is online, I will post the link here.

 

Dominik.