Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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:
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
Solved! Go to Solution.
Hi @rks
Could you use the built in theme editor to tweak your custom one:
This will change the default backgrounds to the same colour:
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.
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?
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.
Hi @rks
Could you use the built in theme editor to tweak your custom one:
This will change the default backgrounds to the same colour:
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
55 | |
54 | |
36 | |
34 |
User | Count |
---|---|
76 | |
73 | |
46 | |
45 | |
43 |