Help with applying multiple specific colours in P.BI Themes using custom .json files

[Anonymous]

Hey everyone,

If have the column Country and then in that clolumn I have France, Germany, England ect how would I do the following in a .json file?

For column Country:

France = yellow

England = blue

ect

I know there is a custom colour theme creator available so my aim was to use that and then implement this into that.

EDIT: Reason being I have 100+ brands and each has their own colour I want to apply this to the theme file so all of my graphs use this colour coding system. I don't fancy applying all of this to each page individually.

Any suggestions will be most helpful.

Thanks!

[MattAllington]

You cannot set the sort order to align to your data in a theme file.  You could try determining the sort order of your data, and then ordering the colour in your theme file in the same order. You may get lucky

[MattAllington · Accepted solution]

My article here covers this. https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/

[Anonymous]

Thank you for suggesting DAX for this over writing in a .json file. I used your idea to have a google and instead of using variables and an if statement I used the following with your method and it worked:

Colourformatting =

SWITCH(

TRUE(),

SELECTEDVALUE(Table[Country]) = "Germany" , "#ff0000",

SELECTEDVALUE(Table[Country]) = "France" , "#ffff99",

SELECTEDVALUE(Table[Country]) = "England", "#ffbf00",

"000000"

)

[MattAllington]

Great.  For bonus points, you could create a master data table in Excel containing the country name and the HEX code you want to use.  Then load that table and write your measure in such a way that it loads the values from your table. The benefit is that it is easier to maintain.

[Anonymous]

Hi Matt, thank you for your response but I am referring to applying a custom theme by importing a .json file so this would not be written in DAX. Reason being I have 100+ brands and each has their own colour I want to apply this to the theme file so all of my graphs use this colour coding system.