Displaying red indicator if a value in a column becomes 0 or green if the value is not 0

[HamzaAhmad]

Hello,

I have a table which calculates the material balance at each stage of production. I need to display red circular indicator if the material balance gets to 0 and green indicator if it is not 0.

I have read the topics and the guides on how to display images using their image URLs. The green and red indicator image URLs are in a new table and the Data Category has been set to Image URL in the Modelling tab. But still, I am unable to display the images. I greatly appreciate your help.

In this screenshot, different materials are shown and their balance is not 0 at the moment, hence I want to show green indicator in a new column next to 'Diff'.

Screenshot below:

[stretcharm · Accepted solution]

I just created a simple expression and set it to Img Url  and dragged it to my table.

Image = if (Table1[KPI]=0 , "https://st.depositphotos.com/1012074/2198/v/950/depositphotos_21989189-stock-illustration-icon-depicting-a-green-traffic.jpg" , "https://st.depositphotos.com/1012074/2198/v/950/depositphotos_21987991-stock-illustration-vector-glossy-icon-depicting-red.jpg")

It didn't work with some images not sure why. I got a broken image icon.

There is also a custom visual that does kpis.

https://appsource.microsoft.com/en-us/product/office/WA104380980?src=office&corrid=f3a388b7-6291-41e...

[HamzaAhmad]

Thank you @stretcharm

Works like a charm (Pun Intended)!