Forum Discussion

PaulBI's avatar
PaulBI
Frequent Visitor
7 years ago
Solved

Icons Conditional Formatting by Field

I've been successfully conditional formatting Background and Font color by field for a while, but has anyone had any success in using the 'by field' conditional formatting for Icons?  It's an availab...
  • jdbuchanan71's avatar
    7 years ago

    Hello PaulBI 

    Are you having trouble getting the incon names to use?  Anonymous put together a list in one of his posts from another source you could take a look at.

    https://community.powerbi.com/t5/Desktop/What-are-the-icon-IDs-In-July-update/m-p/752075#M362440

    In this example, I wrote a measure to read the value of my measure then a switch to set the icon.

    Format Notes = 
    VAR TheTest = SUM (Notes[Notes] ) / 100
        RETURN
        SWITCH ( 
            TRUE(),
            TheTest < .2, "CircleEmpty",
            TheTest < .4, "Circle25",
            TheTest < .6, "CircleHalf",
            TheTest < .8, "Circle75",
            "CircleFilled"
        )

     

    Then I use conditional formatting > Icons on the measure I am trying to highlight and pick 'Fileld Value', and use my formatting switch measure from above.