DAX Query Condition Misbehaves - Power BI

[Anonymous]

I created a calculated column COSTIndicatorColor to control the color of a rectangle shape. (Red, Yellow and Green) However sometimes the rectangle shape becomes default white when multiple values are available for a single ID.

Sample Power BI File with Dataset - https://1drv.ms/u/s!Ah-kO6CqeTNOgh8lcsQahymsIZj_?e=BSuXDf

In this file, whenever we select a project UID in slicer, you can see the table contains around 3 values and one of the value has blank for color indicator. I need to avoid it by fixing green color there or take only any of the value which has color in it for controlling the color or rectangle.

Kindly help.

es and other some values too. What would be the reason and solution ?

[amitchandak · Accepted solution]

@Anonymous , for conditional formatting it always better to have a measure that calculates shape and color.

Because column needs to min/max in visual tbale.

Refer to later part of this blog https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/