Formatting in Power BI

[Anonymous]

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

[v-piga-msft]

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

[Anonymous]

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?

[amitchandak]

Check if this can help you

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting