How to change cell color once date is added

[PabloGiraldo]

Is it possible to change cell color once date is added? Please see screenshot

[PabloGiraldo · Accepted solution]

I ended up figuring this out myself after doing more research.

Created the measure below.

Then went back to table and did conditional formating for that column as shown below.

[Ritaf1983 · Accepted solution]

Unfortunately, it is no way to filter visual based on formatting style, but you can  filter it by the field it self .
Create a column in which the result is "scheduled"  / "not scheduled" and use it as a filter...

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Ritaf1983]

Hi @PabloGiraldo 
In this way, it's really hard to understand what needs to be done.
Please attach a table or file that isn't a screenshot.
So picture with an example of the desired result?

[PabloGiraldo]

@Ritaf1983 

Dates in columns are added throughout the month after training is scheduled. If no date is added, leave cell blank. If date is added, highlight cell red. Added another screenshot with desired outcome and link to the actual file i am working with. Thank you!https://walshgroup-my.sharepoint.com/:u:/p/pgiraldoclavijo/EUTPKcpcsixDs0CcdxxHaFgBhI0Iex3jsZoYg0SZl... 

[PabloGiraldo · Accepted solution]

I ended up figuring this out myself after doing more research.

Created the measure below.

Then went back to table and did conditional formating for that column as shown below.

[Ritaf1983]

Hi @PabloGiraldo 
Great and you can achieve it without measure, with formatting options only (you just choose the desired column and apply steps like on the picture)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly 

[PabloGiraldo]

Thank you!

One more question on this. Is there a way to filter the entire table by the higlighted red cells?

[Ritaf1983 · Accepted solution]

Unfortunately, it is no way to filter visual based on formatting style, but you can  filter it by the field it self .
Create a column in which the result is "scheduled"  / "not scheduled" and use it as a filter...

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[PabloGiraldo]

This worked perfectly. Is there a way to create a measure that will show me "Scheduled" "Not Scheduled" that includes all other columns? So when i click on the filter it will show me all columns that have dates in them? Sorry in advance but i am very new to this

[Ritaf1983]

Okay, that's fine.
I would like to ensure I understand your needs correctly.
Do you want a slicer that will check whether all columns have dates?
Is that to say that there are no empty cells in the table at all?

Or do you mean a slicer that displays a table containing at least one existing date?

[PabloGiraldo]

I would like a slicer that will check whether all columns have dates. I understand some cells will be empty in table as some columns only have a few dates and others are have a lot more. Thank you again!

[Ritaf1983 · Accepted solution]

Hi @PabloGiraldo 
You can use the same logic as on my last suggestion , but with multiple "and" conditions:

TestScheduled = if('Summary'[Clean Water Testing].[Date] <> BLANK() && 'Summary'[Equipment Training].[Date]<>BLANK() &&'Summary'[Process Training]<> blank()&& 'Summary'[Seeding] <> blank() &&'Summary'[Whole Plant Acceptance and Performance Testing (following Digester Retrofit)] <>  blank() && 'Summary'[Veolia Effort Needed  - Plant Operation of Both Plants ] <> blank() && 'Summary'[Veolia Effort Needed -  Training] <> blank()&& 'Summary'[Veolia Effort Needed - Laboratory  Analysis] <> blank(), "Scheduled", "Not Scheduled")

In your example there are blanks in every row, so all rows are "Not Scheduled"

[PabloGiraldo]

Got it! Thank you for your time!

[Ritaf1983]

Happy to help 😊

[PabloGiraldo]

i hate to ask you another question but i cant seem to get help from anyone else. Last thing i need to create is a slicer or a card? that once i select it, it will show me what has been schedule  "This Week" and "This Month." 

[Ritaf1983]

Hi @PabloGiraldo 
Unfortunately, I haven't fully understood what exactly is needed.
I asked clarifying questions, In the original post of this question.