Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
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?
Solved! Go to 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:
Best Regards,
Giotto Zhi
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:
Best Regards,
Giotto Zhi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |