Forum Discussion

azaterol's avatar
azaterol
Icon for Helper V rankHelper V
4 years ago

Colorful Matrix

Hello everybody,

I have a Matrix where the date is in. I want to get every week in diferent colors. The rows from day 1-7 in green, the rows 8-14 in blue and so on... Is this possible?

 

 

Thank you wish you a great day!

Need Help

4 Replies

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    4 years ago

    azaterol yes it is possible you can create a new calc column like below based on the day of the month

     

    week_col_2 = if ([Day]<=7,"red",if([day]<=14,"green",if([day]<=21,"yellow","blue")))
     then apply the formatting like below
     
     

     


    hope it helps you

     

     

      • negi007's avatar
        negi007
        Icon for Community Champion rankCommunity Champion
        4 years ago

        azaterol you can change the color of any column basis the day like below. now below value column color is changing based on the day.

         

         

         

         

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi azaterol ，

     

    Currently only conditional formatting of values is supported in the matrix, and for row headers only a single color can be used. 

     

     

    You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.