Can some one share how to create dynamic fire burning icon ?

[admin11]

Hi All

[Anonymous · Accepted solution]

Hi @admin11 ,

You can learn it from:

Power BI Icon Names

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@Anonymous  Matt blog post it very helpful

[PhilipTreacy]

@admin11 

Hi Paul,

Download sample PBIX file

You could create a Custom Theme but it's easier to create a table in Power Query with the URL for the icon, then use Conditional Formatting to insert the icon.

Refer to Include Custom Icons in Your Tables - Microsoft Power BI Community 

Please note, make sure you are using images/icons that are not copyrighted, or that you have permission to use.

Regards

Phil

[PhilipTreacy]

@admin11 

That'll be an animated GIF, like this

Animated_fire_icon.gif (200×200) (nocookie.net) 

Regards

Phil

[admin11]

Hi Philp

The internet link below is i need to have internet connection , if no internet connection , the fire will stop buring right ? 

[admin11]

Hi Philip

Thank you very much for your help.

May i know how to save the file to my image folder ?

Paul 

[PhilipTreacy]

@admin11 

Hi Paul,

You're forgetting to @ me in replies ! 🙂

The image has to be on the internet somewhere to be loaded.  You'll have to use a free file hosting service.

Regards

Phil

[admin11]

@PhilipTreacy  After you teach how to use @ , i alway @ other but some how i forget @ you. So sorry. Now my head still thinking , if i have a ratio value from 1 to 3 good , and 3 above is bad , may i know how to link them ? How to create the expression to link them ?

https://www.dropbox.com/s/jkdgs9avvx2kxk3/PBT_V2021_141%20fire%20burning%20icon%20v001.pbix?dl=0

Paul

[PhilipTreacy]

@admin11 

No worries.

Download this file

To add a fire icon for values above 3:

1. In Power Query, change the values to Whole Number.

2. Add a column that contains the URL for the icon if the value is greater than 3.

3. Close and Apply

4. Select the Table visual and under Format -> Conditional Formating, turn on Icons.  

5. The CF pop-up window will appear.

6. Set the CF rules to Format By : Field value and Based on field : Icon (it'll show First Icon in the box after you select it)

7. Click OK

[admin11]

@PhilipTreacy 

Thank you for sharing.  now i understand how it work , it there a simple way to duplicate the row ? as my table is display the inventory ratio , the ratio is vari from 1 to 100. 

[PhilipTreacy]

@admin11 

Hi Paul,

When you create the Custom Column in Power Query it creates a row (containing the icon URL) for every row that already exists in your table.

Just add a Custom Column using the criteria I used in my image above and you'll see.

Regards

Phil

[admin11]

@PhilipTreacy 

[PhilipTreacy]

@admin11 

I don't know what you are doing so I don't know why it isn't working for you.

Can you please send me your PBIX.

Thx

Phil

[admin11]

@PhilipTreacy 

Thank you philip for your help :-

https://www.dropbox.com/s/us0bfkm30fwsbp0/PBT_V2021_141%20fire%20burning%20icon%20v001%20SOLUTIONv1....

Paul

[PhilipTreacy]

@admin11 

Hi Paul,

You haven't applied the Icon Conditional Formatting.

See Steps 4,5,6,7 above in one of my earlier posts.

Regards

Phil

[admin11]

@PhilipTreacy 

I have add fire icon to my doc  , my inventory table also have RATIO field have traffic light color , which i like to replace with fire icon. Hope you can advise me how to link them. 

My PBI file :-

https://www.dropbox.com/s/yegu4k27lbqpizt/PBT_V018.pbix?dl=0

Paul

[PhilipTreacy]

@admin11 

Hi Paul,

I can't modify your PBIX file for you because it requires authentication to the data source and I can't do anything without that.

What you need to do is create a column in your INVC table exactly as I did for my Ratio table, and this column will have the URL for the fire image in it.

Then create the Conditional Formatting rule for the RATIO measure in your table.

Regards

Phil

[admin11]

@PhilipTreacy 

I have read twice , you asking me to create a RATIO field with fire icon at INVC table. which i not able to add new column , so i add new RATIO table , and i try to link the RATIO field from these 2 table , but PBI does not allow me to link them , may be you can explain to me how to add new column at my INVC table again. 

[admin11]

@PhilipTreacy 

Thank you very much ,  wow many step , but worth it.

[PhilipTreacy]

@admin11 

Hi Paul,

Great, so you've got it all working now following my instructions?

Once you know the steps it becomes easier and faster.

Regards

Phil