Forum Discussion
Assigning colours in json file
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!
Ok, that clarifies it all Frank.
Thank you very much!
Isil
9 Replies
v-frfei-msftCommunity Support
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
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