Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DominikPetri
Advocate V
Advocate V

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 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

 

Please mark Accept as Solution if your question is answered. Kudos gladly accepted. ⇘
1 ACCEPTED SOLUTION

Hi all,

 

you can download the updated version in which I fixed the hex codes bug here:

Office Theme Converter v3 as zip file

 

Let me know what you think!

 

Thanks

Dominik Petri.

 

 

Please mark Accept as Solution if your question is answered. Kudos gladly accepted. ⇘

View solution in original post

23 REPLIES 23
chass
Impactful Individual
Impactful Individual

Very very nice!

 

Chuck Sterling

Beautiful.  Worked great!

Glad to hear @jfaubert!

Please mark Accept as Solution if your question is answered. Kudos gladly accepted. ⇘

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.