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 next 12 months manually for my users.

Please help! Thanks in advance!

 

Thanks,

Ricky

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
     
     

7 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    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

      Hi ryan_mayu  Thanks! But what if my Year is Fiscal Year? Now it is showing for 2024 but not for Fiscal Year.... Please help me

      • 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.