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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
am facing an issue with the output of the below DAX query: Health Indicator = SWITCH ( Projects1[Status], "Critical", UNICHAR(128308), "Watch Closely", UNICHAR(128993), "On track", UNICHAR(128994))
In the report only for Critical status health indicator is showing red circle. For others, it is showing a blank square.
I tried the workaround query provided them as below but no luck: Health Indicator = SWITCH ( Projects1[Status], "Critical", UNICHAR(128308) & " ", "Watch Closely", UNICHAR(128993) & " ", "On track", UNICHAR(128994) & " ")
Can someone please point out the the issue here?
Thanks!
@Anonymous , Created a measure like this and it is working
Measure 7 = SWITCH ( max('Item'[Category]), "Category 1", UNICHAR(128308) , "Category 2", UNICHAR(128993) , "On track", UNICHAR(128994) )
Try like
Health Indicator = SWITCH ( max(Projects1[Status]), "Critical", UNICHAR(128308), "Watch Closely", UNICHAR(128993), "On track", UNICHAR(128994))
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
7 | |
7 | |
4 | |
3 |
User | Count |
---|---|
15 | |
14 | |
11 | |
10 | |
9 |