Icons not working with condiitonal formatting

Question

Hi Again,&nbsp;Conditional formatting is getting the better of me.&nbsp;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.&nbsp;However easy as this seems, all my data is returning green icons.&nbsp;

parry2k · Answer

Anonymous&nbsp;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

parry2k · Answer

Anonymous&nbsp;in visual are you showing count of key?

anonymous · Answer

no, just need to show the icon red or green&nbsp;parry2k&nbsp;

parry2k · Answer

Anonymous&nbsp;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 · Answer

parry2k&nbsp;It is table and not matrix. (Should i be using matrix?) Key column is set as dont summarize&nbsp;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.&nbsp;FYI im very new to Power BI

Forum Discussion

Icons not working with condiitonal formatting

5 Replies

Related content

Conditional formatting not working

Date Format not working when refreshed

Card (new) conditional formatting not working

Conditional Formatting not working as expected

timestamp custom format for milliseconds not working