Forum Discussion
overdue/on track dates color coding conditional formatting
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!
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
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.
6 Replies
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"
)Thank you! Could you please advise if I should change 'arrow' into my own data name?
amitchandak Could you please advise? Thanks so much for your help 🙂
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.