Matrix visual cell element conditional coloring

[dineshj23]

Hi,

I have a matrix visual that shows the $ amounts and status of Sales by PO Number. In PowerBI, I only have the amount column and not the status column. I want to color code the $ amounts in the visual based on the status column. If the Sales 1 Status is approved, then the color should be green. If not, then it should be red color. I tried this with the conditional formatting but as you can see sometimes, there is more than one value per PO. 

I have already created a measure that exculdes the Voided status amounts. The amounts $ in the visual are from this measure. Below is the measure I have. 

"Sales 1 Total = calculate(sumx(Filter('Document',[Sales1Status] = "Approved" || [Sales1Status] = "TBD"),('[Sales 1 Amount])),USERELATIONSHIP('Calendar'[Date],[Sales 1 Date]))"

Thank you all. 

[dineshj23]

@amitchandak Thank you for your response. 🙂

I didn't understand what you meant above. 

I was able to figure out and did use the conditional formatting to color code the cells according to whether they have been approved or not.

Now, I am having issue with the dates that are blank. If the PO is approved but there is no milestone date, I want it to color the font red. I am using the below conditional formatting but I am not sure "Count of Date" means. I just want it to color the font red if the the milestone date is blank. 

Thank you again!

[amitchandak]

@dineshj23 , You can use that measure to return the color.  You can use that in the field value option

examples

Colour =
SWITCH(TRUE(),
'Table'[Date] < TODAY(), "red",
'Table'[Date] = TODAY(), "orange",
"green")

Colour =
SWITCH(TRUE(),
max('Table'[Month Year]) = "Jan-2020", "red",
Max('Table'[Month Year]) < "Feb-2020", "orange",
//keep on adding
"green")

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[dineshj23]

@amitchandak I tried your way to create a measure then use the field value. However, I got the below error of not being able to find a single value for a column.

As you can see, I have several PO numbers with different dates for each PO. I can't use min or max since they are all independent of each other.