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
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))
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.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 8 | |
| 8 | |
| 7 |