Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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/
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.