Colorful Matrix

[azaterol]

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!

[v-kkf-msft]

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.

[negi007]

@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

[Syndicate_Admin]

Hey @Syndicate_Admin ,

I want change in the matrix the Day"Tag" column. It is not a value...

Any ideas?

[negi007]

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