Forum Discussion

IBweroP's avatar
IBweroP
Regular Visitor
8 years ago

set background color scale in JSON for PowerBI Desktop - Custom Themes

Hi everyone   Can someone please advise the JSON code to set the background color scale in JSON as I would like to add this to our corporate color scheme JSON file?   The code needs to set the co...
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi IBweroP,

 

If I understand your requirement  correctly that you want to set the theme color in the JSON file that you could use it in your conditional formatting?

 

Do you want to get theme color like below?

 

 

If it is, you could have a reference of this JSON file.

 

Reference:

my test pbix file

Report theme JSON file format

 

Best Regards,

Cherry

IBweroP's avatar
IBweroP
Regular Visitor
8 years ago

Hi again Cherry :smileyhappy:

 

My understanding is that what you describe, sets a single colour scheme for the whole table

 

However what we are trying to achieve is that the table visualisation needs to have

1) a black header, black grid and white rows (which you can set using the method you described in your last post)

2) for any individual column background colour scale (if selected), set that to our company branded red (#C8102E) for low , light brown, (#C1A01E) for center and green (#009A17) for high, as the default scale colors in our corporate theme Json file.

  

 

Your suggestion deals with #1 but does not cover #2

 

The Json files given in the webpage link here https://docs.microsoft.com/en-us/power-bi/desktop-report-themes#how-report-themes-work  dont seem to change the background color scale colors at all in the couple of tests I have done on it so far..

 

As an example, if I set the datacolor in the Json file to only two colors, black and grey, I would expect the background color scale to be black and green but it does not change it from the Power BI default.

 

Thanks