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

You can do the similar way. Is the month and year from date table? Are they fiscal year and month?

Maybe just add the fiscal yar to the conditional format setting and set to 2024. 

 

if still not work, pls provide some sample data.

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