The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Experts,
I would like to create a conditional formatting icons to the below 'Meeting Schedule Deadline Status' column.
The conditions would be:
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!
Solved! Go to 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
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
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 , 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?
@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"
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
138 | |
106 | |
105 | |
73 | |
60 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
88 |