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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

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
Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.