Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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!

1 ACCEPTED SOLUTION

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



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

5 REPLIES 5

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



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Anonymous
Not applicable

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"
)

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.



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Anonymous
Not applicable

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors