Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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

 

image.png

 

I have attached a PBIX under my signature.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

8 REPLIES 8
amitchandak
Super User
Super User

@Anonymous 

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

 

Anonymous
Not applicable

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

 

Any other ideas?

 

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

 

Anonymous
Not applicable

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

 

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

 

image.png

 

I have attached a PBIX under my signature.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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.

 

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

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

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

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.