This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 23 | |
| 23 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 63 | |
| 38 | |
| 25 | |
| 23 | |
| 22 |