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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
servicepowerbi
New Member

Conditional formating

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?

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

Hi,

 

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

91.png

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:

92.png

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

93.png

94.png

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

 

Here is my test pbix file:

pbix 

 

Best Regards,

Giotto Zhi

 

View solution in original post

1 REPLY 1
v-gizhi-msft
Community Support
Community Support

Hi,

 

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

91.png

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:

92.png

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

93.png

94.png

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

 

Here is my test pbix file:

pbix 

 

Best Regards,

Giotto Zhi

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.