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 amitchandak
Thank you for the reply
I create a measure like this :
Mesure Jourcouleur =
SWITCH(
SELECTEDVALUE(Comptage[jour]);
"JOB";"#009AA6";
"Samedi";"#A1006B";
"Dimanche";"#659200")
Its working
But When i choose 2 years, But when I choose 2 years, it works for both. Now I would like that for the previous year, the color be gray and for the current year, the colors that are in the measure
Thank you
Combine with max year and create one or more combinations
If(max(Table[year]) =2007,
SWITCH(
SELECTEDVALUE(Comptage[jour]);
"JOB";"#009AA6";
"Samedi";"#A1006B";
"Dimanche";"#659200"),
///change the color for another year
SWITCH(
SELECTEDVALUE(Comptage[jour]);
"JOB";"#009AA6";
"Samedi";"#A1006B";
"Dimanche";"#659200") )