Forum Discussion
overdue/on track dates color coding conditional formatting
- 5 years ago
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"
) - Anonymous5 years ago
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.
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 🙂