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

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Milozebre 

 

You can add a  day of the week number column to your date dimension, later use it for conditional formating of you chart as below

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • Milozebre's avatar
    Milozebre
    Helper V
    6 years ago

    Hello Mariusz 

     

    thank you for the reply. 

    As you can see on the chart above, what is gray is the year of analysis ex 2018
    and in blue, the year of comparison. Gray can't change.
    The analysis year which is a parameter must always be gray and the year of comparison on the basis of days must have the predefined colors.
    I wanted to make measurements with Swhith but I don't know how to incorporate the parameters:
    Year analyze = "Gray"
    If day = "Job" with Year comparison; "Red"
    for example