overdue/on track dates color coding conditional formatting

[Anonymous]

Hi Experts, 

I would like to create a conditional formatting icons to the below 'Meeting Schedule Deadline Status' column.

The conditions would be:

• Green = date < today
• Red = date > today

Meeting Schedule Deadline	Meeting Schedule Deadline Status
6/5/2021	icon red
7/19/2021	icon green
7/5/2021	icon red

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

[amitchandak · Accepted solution]

@Anonymous , You can create icon measure and color measure and add an icon as the new value and do conditional formatting on that using field value

Arrow =
var _change =Max([Meeting Schedule Deadline]) >today()
return
if (_change, UNICHAR(9650),UNICHAR(9660)
)

/////Arrow Color
Arrow color =
var _change =Max([Meeting Schedule Deadline]) >today()
return
if (_change, "green","red"
)

[Anonymous · Accepted solution]

@Anonymous 
There is already icon feature in Power BI. Right click the field and select icon, you may refer to the link:

Conditional Formatting Using Icons In Power BI - Excelerator BI

And for UNICHAR() code, please refer to:

DAX UNICHAR Function in Power BI - Excelerator BI

Basic Latin — ✔️ ❤️ ★ Unicode Character Table (unicode-table.com)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , You can create icon measure and color measure and add an icon as the new value and do conditional formatting on that using field value

Arrow =
var _change =Max([Meeting Schedule Deadline]) >today()
return
if (_change, UNICHAR(9650),UNICHAR(9660)
)

/////Arrow Color
Arrow color =
var _change =Max([Meeting Schedule Deadline]) >today()
return
if (_change, "green","red"
)

[Anonymous]

@amitchandak 

Thank you! Could you please advise if I should change 'arrow' into my own data name?

[amitchandak]

@Anonymous , what do you mean by own data name?  you can change the column name and unichar character you want

list of unichar

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

refer examples

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

refer my video : https://www.youtube.com/watch?v=veCtfP8IhbI

[Anonymous]

@amitchandak Got it. Is it possible to create one icon measure with colors? 

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 and let me know if the below coding is accurate for this? Thanks so much for your help.

Arrow =
var _change =Max([Meeting Schedule Deadline]) >today()
return
if (_change, UNICHAR(11044), "green","red"
)

[Anonymous]

@amitchandak Could you please advise? Thanks so much for your help 🙂