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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
rks
Resolver II
Resolver II

Change ColorIds dozens of visuals without clicking

Hi Community,

 

We have changed the order of the datacolors in our JSON Template. For future use, this is the correct order. However, now many colors of buttons etc look off: 

rks_0-1723790741191.png

This used to be a grey background... I have around 100 visuals that are affected. Other colleagues facing colour issues, too. The background color is bound to a certain ColorId (Theme Color). Of course, after change the data colour-order, the Ids have changed, too.

I know there's the new feature (currently in preview and with certain limitations) to use the PBIR - format and do a search&replace for the entire report to find ColorId 4 and replace it with ColorId 3. Unfortunately, due to it being in Preview there a limitations (one is that the saved PBIR file can't be opened in the first place - but that's a different story).

 

My question is, whether there's a way to avoid changing the colour manually for all those visuals and not use the PBIR files?

 

Best regards,
Konstantin

1 ACCEPTED SOLUTION
SamWiseOwl
Super User
Super User

Hi @rks 

Could you use the built in theme editor to tweak your custom one:

SamWiseOwl_0-1723792254030.png

 

This will change the default backgrounds to the same colour:

SamWiseOwl_1-1723792284583.png

The other option would be to use the Save Theme option to export the JSON file.

Then edit the JSON file itself, that way you could use find and replace, this is a website I like:

https://jsoneditoronline.org/#left=local.qasewa

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

View solution in original post

4 REPLIES 4
rks
Resolver II
Resolver II

Thanks for the the info. This doesn't solve the problem. What I would need is to change the ColorId of the Visual and not the color ID of the theme. 

 

But probably the future solution would be to save the file as a pbir and search and replace the color-Ids....

Did you try exporting the JSON file and editing that?

SamWiseOwl_0-1724232621303.png

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Yes. That was the change in the first place. Because of editing the JSON the colours-order was changed.

 

If you choose a custom color from the color picker, the ColorId is saved in the report's visual, not the color itself. So if you change the order of the data colors in the JSON you have different colours on the visuals.

SamWiseOwl
Super User
Super User

Hi @rks 

Could you use the built in theme editor to tweak your custom one:

SamWiseOwl_0-1723792254030.png

 

This will change the default backgrounds to the same colour:

SamWiseOwl_1-1723792284583.png

The other option would be to use the Save Theme option to export the JSON file.

Then edit the JSON file itself, that way you could use find and replace, this is a website I like:

https://jsoneditoronline.org/#left=local.qasewa

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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