overdue dates indicator color coding

[Anonymous]

Hi Experts, 

I would like to create indicator icons to the below 'Meeting Schedule Deadline Status' column.

The conditions would be:

●= date < today

●= date > today

Meeting Schedule Deadline	Meeting Schedule Deadline Status
6/5/2021	●
7/19/2021	●
7/5/2021	●

Could you please advise what would be the simpliest way to write code for this? Thanks so much for your help!

[Anonymous]

I would like to create indicator icons to the below 'Meeting Schedule Deadline Status' column.

The conditions would be:

●= date < today

●= date > today

Meeting Schedule Deadline	Meeting Schedule Deadline Status
6/5/2021	●
7/19/2021	●
7/5/2021	●

Could you please advise what would be the simpliest way to write code for this? Thanks so much for your help!

[Anonymous · Accepted solution]

HI @Anonymous,

Did you mean to create a column with different icons based on current date values?
If that is the case, you can create a calculated column with the if statement and use Unicode characters to show these special icons.
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , I updated my comments on

https://community.powerbi.com/t5/Desktop/overdue-on-track-dates-color-coding-conditional-formatting/m-p/1964670#M744782