Icons not working with condiitonal formatting

[Anonymous]

Hi Again,

Conditional formatting is getting the better of me.

I am using the icons to highlight if Red or Green basis the IF formula used that returns 1 (if Current is LESS than Last) and 3 if not true to this statement.

So 1 should be green, 3 should be red.

However easy as this seems, all my data is returning green icons.

[parry2k]

@Anonymous in visual are you showing count of key?

[Anonymous]

no, just need to show the icon red or green @parry2k 

[parry2k]

@Anonymous are you using matrix visual, the key column you used in the visual, what is the aggregation method for it or it is dont summarize?

[Anonymous]

@parry2k It is table and not matrix. (Should i be using matrix?) Key column is set as dont summarize 

I created "key" column to replicate what is in "status"column as when doing the conditional formatting it did not allow me to use "status" assuming becuase it is a measurment.

FYI im very new to Power BI

[parry2k]

@Anonymous conditional formatting works on measures, when you configured conditional formatting, you mentioned count of keys which in a way is a measure, so in table visual, instead of don't summarize, change it to count and it should work