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,
I try this measure :
Mesure Jourcouleur2017 =
SWITCH(
TRUE();
SELECTEDVALUE(Calendrier[Year]) = 2017;"#B3B3B3";
SELECTEDVALUE(Calendrier[Year]) = 2018; "#E3E3E3")
Its working, if i choose only year.
But I need to add a legend (jour)
When i put in legend (see image), i loose my conditionnal formating.
Is it possible to say in the measure below.
For year 2017 and for all "jour" for 2017 the color is Gray and for the others years 3 others colors ?