We are using the same template with our company colors for all our reports, which works fine. However, I've found (and read in topic https://community.powerbi.com/t5/Desktop/Report-Theme-Colors/m-p/242920#M107802) that the data colors are used in the order in which they are listed in the JSON file.
Is there a way to 'turn this order around'? What I mean: we have different reports, where the current year is of course 2018, and for business understanding I want the current year to be displayed in bright orange, last year in grey, the year before that in black, and so on.
I encounter two problems here:
1. Some reports have data from 2013 to current year, others f.e. from 2016 to current, so I cannot set the first color on black, then grey etc, because this will not turn 2018 orange in all the cases
2. It will be 2019 someday, where the current orange year is not the current anymore
My solution would be to use the colors 'backwards', but I don't think there is an option like that, is there? Or would there be another solution to achieve this goal and not have to change each and every visual separately?
Thanks!
Pauline
(PS: what I could do is set a template per datamodel, making sure 2016 is black, 2017 grey, 2018 orange by counting the years before that and give those different colors, but this is not very sustainable and does not fix question #2)
