cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbertlin
Frequent Visitor

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

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.

Health column.PNG

 

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

Health icons settings.PNG

No icons are displayed in the column.

Health column as icons.PNG

 

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

 

Thanks in advance.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

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

@bbertlin - 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:

 

image.png

 

I have attached a PBIX under my signature.

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

8 REPLIES 8
Super User IV
Super User IV

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

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

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User IV
Super User IV

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

@bbertlin 

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

 

Conditiona format Icon.png

 





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


bbertlin
Frequent Visitor

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

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

 

Any other ideas?

 

Super User IV
Super User IV

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

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

 





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


bbertlin
Frequent Visitor

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

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)?

 

Super User IV
Super User IV

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

@bbertlin - 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:

 

image.png

 

I have attached a PBIX under my signature.

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

bbertlin
Frequent Visitor

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

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.

 

Super User IV
Super User IV

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

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

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors