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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Removing user defined formatting from a PBIX file

Hi All,

I have developed a  PowerBI Theme file (JSON file) for our company. This defines the company colors, font sizes etc.

We need to retrospectively apply this theme to a large number of existing PBI reports that don't meet the company's style guidelines. 

 

The problem with these old reports, is that importing a JSON theme file, doesn't over ride user defined formatting. This is expected behavior as outlined here : https://docs.microsoft.com/en-us/power-bi/desktop-report-themes#situations-when-report-theme-colors-...

 

 Therefore we are forced to manually reset these user defined formatting- which is time consuming. 

 

Can anyone suggest a way to remove user defined formatting, so that the Theme formatting can be effeciently applied?

As a heads up - I have tried digging into the  unzipped PBI files and deleting out existing JSON files in the "Base Themes folder- but user defined formatting don't appear to be controlled by JSON files. 

 

Any help would be appreciated.

Cheers

Steve

 

 

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@Anonymous ,

 

As far as I know, there is no elegant way. You may try Format Painter and submit an idea.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@Anonymous ,

 

As far as I know, there is no elegant way. You may try Format Painter and submit an idea.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Did you find a solution to this? I am facing the same issue.

 

Thanks!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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