Forum Discussion
PaulBI
7 years agoFrequent Visitor
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...
- 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.
PaulBI
7 years agoFrequent Visitor
That's exactly what I was looking for. I was hoping there was a way to use one measure to set both icon and font at the same time, but a table of the icon names that I can set a second measure to works as well.
Thanks