The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
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 |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |