Forum Discussion
Helper IIIUsing 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?
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.
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/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.
4 Replies
- amitchandak
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
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.
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/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.can you please explain the solution on this.even i am having same challenge
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
