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 want to make color based formatting in power BI basaed on 2 cells.
I have bid submission date and Project value.
If IT estimates are not submitted within 1 week of the submission date turn the background of the cell red. How do I do this? How will power BI know it's within 1 week?
Below you will find the date. For example, if today is 7/25/18 and my submission date is 8/01/2018 and the estimate value has not been submitted and I'm within the 1 week time frame the Estime value cell should turn red.
Bid Submission Date
05/28/18 |
12/13/17 |
09/12/17 |
02/19/18 |
06/30/18 |
03/31/18 |
05/19/15 |
01/28/18 |
04/08/18 |
11/20/17 |
02/18/18 |
05/08/18 |
04/01/18 |
08/01/18 |
Estimate Value
$- |
$100 |
$350 |
$5000 |
$2,225 |
$3.4MM |
$24.946MM |
344K |
Hi @Anonymous ,
If IT estimates are not submitted within 1 week of the submission date turn the background of the cell red. How do I do this? How will power BI know it's within 1 week?
Does 1 week mean 7 day or the same week?
I think you could calculate the difference between the two dates to check if that is within 1 week.
In addition, I'm a little confused about the data your shared. How do we know that if the estimate value has been submitted on 8/01/2018?
If you still need help, please share the data sample which could reproduce the scenario and your desired output so that we could help further on it.
Best Regards,
Cherry
7 days. How do I calculate?
8/01 was just an example, but that's the thing how would we know if its been submitted under one week?
Check if this can help you
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |