Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 available option, but everytime I use it, it just removes any icons.
The measure I had been using for background and Font were the typical "Red" and "Green" (and worked for background and font) but no luck using that same measure for the icons.
Any help would be greatly appreciated.
Thanks!
Solved! Go to Solution.
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.
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
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.
Hi, i'm trying to do the same - create a Measure for icon formatting and use it in table - however after creating measure and applying it into conditional formatting option in table options my unichar icons are not encoded. Does anyone know how to solve that?
Below my measure, result in table and conditional formatting.
Thanks
@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)
)
Ok - solved. It seems like some of the icons have issue with this scenario of usage. I've changed them on different and it works.
Thanks.
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.
Hi
This was really helpful! I have a question though:
How does one remove the text form the same column as where the icons are? I see in your example, the icons are in their own column, but when I follow the same steps, my column contains the icons on the left, and the text on the right. How can I only show the icons and not display the text?
Thank you in advance.
Hello @Anonymous
In the conditional formatting window you can set it to show icons only.
Thank you, this is extremely helpful.
I am trying to create a similar code to populate cells with an Icon, however I am unable to use UNICHAR() to create an Icon as shown below.
Hello @Earosenfeld
I was able to use the UNICHAR function wtih no problem. Here is the sample measure I tested.
Formatting = VAR Mtl_Sub = SELECTEDVALUE(ENG_DATA[Subject]) VAR Mtl_Val = SELECTEDVALUE(ENG_DATA[Value]) VAR _ThumbsUp = UNICHAR ( 128077 ) VAR _Smiley = UNICHAR ( 128578 ) VAR _Frown = UNICHAR ( 128577 ) VAR _Neutral = UNICHAR ( 128528 ) RETURN SWITCH( TRUE(), Mtl_Sub = "MtlAdded" && Mtl_Val = "1",_ThumbsUp, Mtl_Sub = "MtlAdded" && Mtl_Val = "2",_Smiley, Mtl_Sub = "MtlAdded" && Mtl_Val = "3",_Frown, "No Match" )
And it works if it is in a VAR or not.
RETURN SWITCH( TRUE(), Mtl_Sub = "MtlAdded" && Mtl_Val = "1",UNICHAR ( 128077 ), Mtl_Sub = "MtlAdded" && Mtl_Val = "2",_Smiley, Mtl_Sub = "MtlAdded" && Mtl_Val = "3",_Frown, "No Match" )
Does this help at all?
Hi, how did you keep field "No Match" when I do conditional formatting, I can choose either only icons or text next to icon, i used the same formula as you and the text " No match" doesn't show
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |