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
     
     
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have linked the actual date to the Dates table which is shown below.

When i try to add the Fiscal Year it always show as a SUM which is incorrect

 

 

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