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