Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Dear community,
Good day!
I need guidance on how to display the icons (conditional formatting), when user forgets to fill in the date.
The condition is:
Expected outcome:
Appreciated any help provided.
Attached pbix: https://drive.google.com/file/d/1QtPNtqjQIevB38guOU57ZT3f679ueK3z/view?usp=sharing
Thank you!
@NickProp28 , You have to create a measure which return unichar or date or use icon conditional formatting
if(Left(max(Table[Term])) = "D" && isblank(max(Table[ATA])) ,1,blank())
and you can use icon formatting using this measure
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
https://exceleratorbi.com.au/dax-unichar-function-power-bi/
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!