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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.