Forum Discussion
Help with applying multiple specific colours in P.BI Themes using custom .json files
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!
My article here covers this. https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/
5 Replies
- MattAllington
Community Champion
My article here covers this. https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/
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.
- 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