Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Icons not working with condiitonal formatting

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 i...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous in visual are you showing count of key?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        parry2k
        Icon for Super User rankSuper User
        6 years ago

        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