sorting json colors by individual diagram and not by page

[Anonymous]

Hi BI-buddies,

Having an issue where i'm importing a custom json file into BI. When doing this, the colors are sorted for the whole page, meaning that color 1,2,3 in the json is placed in diagram 1, color 4,5,6 in diagram 2 and so on..

I want the sorting order to reset for each indiviual diagram, so that color 1,2,3 are always the first to be chosen for each time, and to select this manually for each diagram is not an option since i have 100+ reports to fix. 

So, are there any other ways to do this through the coding in the json file? or maybe through some default setting in powerBI?

Grateful for all the input i can get on this one.

Stay safe and healthy!

/Bee

[Anonymous]

HI @Anonymous,

Nope, power bi does not support use theme to setting calculated based on visual order.  For advanced color formatting, I'd like to suggest you use the 'conditional formatting' feature on your visual based on measure value.
Regards,

Xiaoxin Sheng