Conditional formating

[servicepowerbi]

I have a histogram (link below) grouped by 5-days. the left one is October, central is November and the right one is December.

Yellow is from 1st till 5th day of each month, 11 till 15...

Grey is from 6 till 10...

https://prnt.sc/qd3bgo

These colors are set manually in Data colors menu. And when the new 5-days starts (for example it is yellow now, on 21 December a new group will be created), the new created group will become random colored. And i need to set is grey manually.
How can i make a conditional formatting for this situation, could you help please?

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, I create a table to test:

Please take following steps:

1)Choose a line and stacked column chart and set the color.

2)Create a column:

Group = ROUND([Date Start].[Day]/5,0)

3)Add this column to visual’s column series instead of original group:

4)Add a date filter on this page, for different filter, it shows:

And the new data color is synchronized with the original format.

Here is my test pbix file:

pbix 

Best Regards,

Giotto Zhi