How can I create a measure that accounts for conditional images based on profit percentage?

[Anonymous]

Hello,

I'm trying to apply a Smiley Face image for profits above 30% and a Frowny Face image for profits below 30%.

I have a measure accounting for Total Cost. However how can I apply another measure accounting for the percentages?

I currently have IF(TotalCost) > _____________, image url.

I'm unsure what to put after the > sign.

Thank you.

[amitchandak]

@Anonymous , You can create a measure like example

if([TotalCost] > 80 'image url' , 'image url2')

and you can mark it as type URL

Also refer icon formatting using unichar

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[Anonymous]

Is there a way to input something that indicates a percentage of Total Cost into that IF statement?

[v-easonf-msft]

Hi, @Anonymous 

Could you please tell me whether your problem has been solved?

If yes, you could accept the helpful answer as solution. You could also share your own solution here.
For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

It has been solved. I marked the correct response as solution. Thanks!

[amitchandak · Accepted solution]

@Anonymous , Pecercent if marked as percent column will have value like .1 for 10 %

example

Switch( True  (),

[Percent measure] < .2  'image url',

[Percent measure] < .4  'image URL 2'

, 'image url3')