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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MEFOX
Helper III
Helper III

Using Json file to change report colors

I changed a Json Theme file I exported from a Power BI report to test the ability to change the colors used in existing reports. I imported the Json file back into the report after changing the color codes but it seems not to have any impact on the existing colors. After re-exporting the theme file it seems to have been appended with the other colors that were already in the report. Maybe I'm headed down the wrong path. I need to change about 10 reports in a dashboard and I don't want to change every visual one at a time?  Is there a method to change all the colors used in an existing report to a new set of colors and reuse this method for the rest of the reports in the dashboard?

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

Hi @MEFOX ,

 

Have you followed the correct steps as listed in official documnet:Use report themes in Power BI Desktop - Power BI | Microsoft DocsTo my knowledge, In a report theme JSON file, you define only the formatting that you want to change. Whatever you don't specify in the JSON file reverts to the Power BI Desktop default settings.

 

If you want to always use the same theme, you could export the pbix(just choose the theme you want) to Power BI Templete, then everytime you open it, the theme is always the same.

export to template.jpg

 

In addition, I have found some similar submitted ideas, you could give your votes at them,May be , hopes Power Bi will implement this in nearby future.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35875762-ability-to-update-themes...

https://ideas.powerbi.com/ideas/idea/?ideaid=1a964ccb-8474-44ec-b5b5-0d085abb6f5f

https://ideas.powerbi.com/ideas/idea/?ideaid=83137c9d-277f-4249-97f7-431cd98409dc

 

Best Regards,
Eyelyn Qin
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

4 REPLIES 4
v-eqin-msft
Community Support
Community Support

Hi @MEFOX ,

 

Have you followed the correct steps as listed in official documnet:Use report themes in Power BI Desktop - Power BI | Microsoft DocsTo my knowledge, In a report theme JSON file, you define only the formatting that you want to change. Whatever you don't specify in the JSON file reverts to the Power BI Desktop default settings.

 

If you want to always use the same theme, you could export the pbix(just choose the theme you want) to Power BI Templete, then everytime you open it, the theme is always the same.

export to template.jpg

 

In addition, I have found some similar submitted ideas, you could give your votes at them,May be , hopes Power Bi will implement this in nearby future.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35875762-ability-to-update-themes...

https://ideas.powerbi.com/ideas/idea/?ideaid=1a964ccb-8474-44ec-b5b5-0d085abb6f5f

https://ideas.powerbi.com/ideas/idea/?ideaid=83137c9d-277f-4249-97f7-431cd98409dc

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 @amitchandak  @Eyelyn9 Please explain more details on this solution.Even i do have 120+Pages and when i am using Custom Theme using JSON My visuals are still Format data colors which were manually set instead of Cusotm Theme

can you please explain the solution on this.even i am having same challenge

amitchandak
Super User
Super User

@MEFOX , If you import the theme it should work. For me very recently it had taken some time to display. On one page it took 1 min to reflect the change.

 

Also, note that the theme will not change any visual where you have done manual changes for font or color

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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