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.
Hi,
I have next matrix in Power BI, where I need to add conditional formatting to value in columns Jan-2010:Jun 2010 based on Start Date and End Date columns. For instance, for the first row the color of 13 and 18 should be red, while 13, 19 14, 10 should be green. How can I approach this problem?
Item 1 | Item 2 | Start Date | End Date | Jan-2010 | Feb-2010 | Mar-2010 | Apr-2010 | May-2010 | Jun-2010 |
S2 | ik22 | 01/11/2009 | 01/03/2010 | 13 | 18 | 13 | 19 | 14 | 10 |
S3 | ik23 | 15/10/2009 | 15/02/2010 | 15 | 20 | 12 | 18 | 11 | 11 |
S4 | ik24 | 01/12/2009 | 20/04/2010 | 13 | 16 | 20 | 11 | 20 | 10 |
S5 | ik25 | 15/11/2009 | 15/02/2010 | 20 | 10 | 13 | 12 | 15 | 16 |
S6 | ik26 | 20/12/2009 | 20/05/2010 | 17 | 18 | 17 | 15 | 16 | 15 |
S7 | ik27 | 23/02/2009 | 23/08/2010 | 16 | 16 | 13 | 20 | 20 | 19 |
Solved! Go to Solution.
Hi @Anonymous
You can do it by creating Measure like below.
Conditional Formatting = SUMX( 'Table', INT ( AND( 'Table'[Date] >= 'Table'[Start Date], 'Table'[Date] <= 'Table'[End Date] ) ) )
And later using it for Conditional Formating like below.
Hi @Anonymous
You can do it by creating Measure like below.
Conditional Formatting = SUMX( 'Table', INT ( AND( 'Table'[Date] >= 'Table'[Start Date], 'Table'[Date] <= 'Table'[End Date] ) ) )
And later using it for Conditional Formating like below.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |