Forum Discussion
Icons Conditional Formatting by Field
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
It looks like maybe the icons won't get applied in the cell? Maybe you can only use the built-in icons work but you can add your formatting measure in another column and they should show up.
Measure 2 =
VAR _Value = [Benchmark_Medical_Claims]
RETURN
SWITCH(
TRUE(),
_Value > 1000, UNICHAR( 9660 ),
UNICHAR(9679)
)
The case is that i would need to place them in the same column. At least i will place them in separte column but that's the last option i'm considering.