Forum Discussion
Solved
Colors based on parameters
Hello Community, I hope you are doing well, you and your families. I have a question, I found the beginnings of answers on this forum but I can't seem to do what I would like. Here is the backgr...
Hello
I dont find solution with a measure.
Anytime I put a legend to see year, its not working anymore.
With the measure and if I put the paramter table as legend and not the Year, its working.
Thank you for your help, youre awesome
Hello Icey ,
I can put some contionnal formating on clustered column chart as you see with this measure (see image) :
Mesure Jourcouleur JOB =
SWITCH(
TRUE();
SELECTEDVALUE(Calendrier[Year]) = 2017;"#B3B3B3";
SELECTEDVALUE(Calendrier[Year]) <>2017;"#A1006B")
But when I put year in legend or if i choose 2 year, its not working, i loose the formatting, thats my problem.
I want to see a color for 2017 and 2018 via the measurement.
Because I would have to have a 2018 and 2019 file.
And in this case, 2018 should be gray and 2019 the other color.
Basically
year min = always gray
max year = custom color.
It works until I put a field in legend
Because I would have to have a 2018 and 2019 file.
And in this case, 2018 should be gray and 2019 the other color.
Basically
year min = always gray
max year = custom color.
It works until I put a field in legend
Thank you
Hello
I dont find solution with a measure.
Anytime I put a legend to see year, its not working anymore.
With the measure and if I put the paramter table as legend and not the Year, its working.
Thank you for your help, youre awesome