Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to do conditional formatting for X columns automatically

Hi I need help to change the color of my Line and Stacked Chart  Basically, i want the FY2024 to be another color than FY2023. I do not want to do it manually as I would then have to do it for the n...
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Anonymous 

    here is a workaround for you.

     

    create measure

     

    Measure = year(max('Table'[date]))
     
    then go to the color setting
     
    then set up the conditional formatting
     
     
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

then you can create a measure

 

Measure = max('date'[fiscalyear])
 
 
 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

It Works!! Thanks so much !

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    you are welcome