Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Icons Conditional Formatting

This works great for the gauges for the conditional formatting of gauges.  But I want to do something very similar for the icons in my table, just like this but to say red/green circles and I can't f...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous choose cpi color 2 on based on the field, and then put the rules for 0 to show red circle or whatever you want to show..you are not sharing full rule screen, I don't know how you expect me to understand what you are doing from half of the screenshot. I have no magical way to figure out the rules

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous keep that color measure as it is, but add a new measure to return 0 and 1 and in the table visual, use conditional formatting for icon set and then use this measure to set the red or green color, check this post how to add icon set

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This is what I currently have that is not working.  

     

    Matrix

     

    % to goal conditional formatting, icons.

     

    CPI color = if(sum('CPI'[% to goal])<sum('Targets'[CPI target]),"#Dc3912",if(sum('CPI'[% to goal])>sum('Targets'[CPI target]),"#109618"))

     

    CPI color2 = if(sum('CPI'[% to goal])<sum('Targets'[CPI target]),1,if(sum('CPI'[% to goal])>sum('Targets'[CPI target]),0))