Need help to get icons in conditional formatting from field to display

[Anonymous]

I can't get icons to display using conditional formatting in my table but I can get background color or font color to work properly from my data set.  I'm trying get basic green, yellow or red colored circles to display.

My dataset for the field (Health) has the color names as values - background and fonts colors work perfectly on this data.

I've defined the conditional formatting icons as show below and nothing shows up.

No icons are displayed in the column.

What do I need to do to get the icons to display?

Thanks in advance.

[amitchandak]

@Anonymous 

Under the conditional format of Table and Matrix you an option for Icon. Switch that On. After that you can use

[Anonymous]

Thanks for the suggestion.  I turned on Icons for the table and it didn't have any effect.

Any other ideas?

[amitchandak]

It should open a popup, where you can choose conditional formatting and icons

[Anonymous]

Yes, a windows opened where I set the conditional formatting for the Health column and the icons still don't display.  Is there somewhere I should be chosing what icons (circles, diamonds, etc.) should be displayed like when using Rules (vs Field values)?

[Greg_Deckler · Accepted solution]

@Anonymous - You will need a measure like this:

Measure = 
    SWITCH(MAX([Column2]),
        "Green",2,
        "Yellow",1,
        "Red",0
    )

Then, set your Icon Conditional formatting Rules up like this:

I have attached a PBIX under my signature.

[Anonymous]

Yep - that's exactly what I did to get it working.  Not sure how Field Value works but by mapping my Health column to a new, numeric column and then using Rules, it works fine.

Thanks everyone.

[Greg_Deckler]

I may be mistaken, but I believe field value with icons requires the field to be an SVG image. Glad you got it!

[Greg_Deckler]

I believe that the field needs to contain an SVG image text.