Forum Discussion

Milozebre's avatar
Milozebre
Helper V
6 years ago
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...
Need Help
  • Milozebre's avatar
    Milozebre
    6 years ago

    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

Icey's avatar
Icey
Community Support
6 years ago

Hi Milozebre ,

 


 

Is this what you want?

If the visual is Clustered column chart, you can't set conditional formating on it. Conditional formatting applies only to the values of Table or Matrix visuals.

So, I'm afraid what you want is not possible currently.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Milozebre's avatar
Milozebre
Helper V
6 years ago

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
 
Thank you 
  • Milozebre's avatar
    Milozebre
    Helper V
    6 years ago

    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