Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
azaterol
Helper V
Helper V

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?

 

xxxxxxxx.PNG

 

Thank you wish you a great day!

4 REPLIES 4
v-kkf-msft
Community Support
Community Support

Hi @azaterol ,

 

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

 

vkkfmsft_0-1654653357491.png

 

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
Community Champion
Community Champion

@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
 
negi007_1-1654167400825.png
 
negi007_0-1654167385908.png

 


hope it helps you

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Hey @Syndicate_Admin ,

ascas.PNG

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

Any ideas?

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

 

negi007_0-1654169168678.png

 

 

negi007_1-1654169184371.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.