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...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi

This was really helpful! I have a question though:

How does one remove the text form the same column as where the icons are? I see in your example, the icons are in their own column, but when I follow the same steps, my column contains the icons on the left, and the text on the right. How can I only show the icons and not display the text?

Thank you in advance.

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

Hello Anonymous 

In the conditional formatting window you can set it to show icons only.