Assigning colours in json file

[Isiluzun]

 Hello everyone,

I was wondering if it is possible to assign specific colours to specific years and to a calculated measure in the report with coding in JSON file. My current theme is as below. I am working on sales data from 2016 to 2018. I would like to use first 3 colours to depict the years 2016 to 2018 and the 4th one to depict the calculated measure that shows the deviation % between 2017 and 2018 in all the visualisation in my report.

{

    "name": "itheme2",

    "dataColors": ["#C00000", "#000000", "#808080", "#ffc000","#B0C6D7","#A9A6BB","#75BDA7","#92D050"],

    "background":"#FFFFFF",

    "foreground": "#FF0000",

    "tableAccent": "#FF0000"

Many thanks in advance!

[v-frfei-msft]

Hi @Isiluzun,

Based on my test, it is not possbile to meet your requirement via json file. You can have a try to use Conditional formatting in the visual.

Regards,

Frank

[Isiluzun]

Hey Frank,

Thank you very much! I also dont have the conditional formatting option! Please take a look below.

Any idea what might be the reason?

Cheers,

Isil

[v-frfei-msft]

Hi @Isiluzun,

What is the format of the column in the value field? If the column is in number format, that should work well.

Regards,

Frank

[Isiluzun]

Hello Frank,

Yes the format is decimal number somehow I do not have the conditional formatting option. Any other way to find this command somewhere else, on the upper ribbon for e.g?

Thank you so much for your help

Isil

[v-frfei-msft]

Hi @Isiluzun,

For pie chart and clustered coloumn chart, we can only change color in the Data color field as the picture as below.

Regards,

Frank

[Isiluzun · Accepted solution]

Ok, that clarifies it all Frank.

Thank you very much!

Isil

[v-frfei-msft]

Hi @Isiluzun,

What visual do you use?

Regards,

Frank

[Isiluzun]

Hi Frank,

I use pie chart and clustered coloumn chart. I dont have conditional formating options for these visulaizations but I have it on my tables for the same values.

Many thanks

regards

Isil

[v-frfei-msft]

Hi @Isiluzun,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank