Hello, thank you for sharing :) I tried to use this method in Power BI, but the report table can't show any of the Icons, and instead it shows them as broken image icons. Do you know how to fix this problem in my case? Thank you!
Not sure why links should be broken I take it you've done all the normal stuff i.e. connected to the internet | ensure that you're firewall isn't blocking etc. Although I use the www.computertutoring.co.uk website you can use this with any images so long as the site your using doesn't have any sort of software blocker otherwise sorry don't know.
Hi I've just discovered that Power BI now allows you to use Icons in Conditional Formatting. (All that hard work for nothing). Anyway I'll add some fancy icons so that it keeps this video relevant and watch out for an updating RAG video.
what about all the orange or amber in between "Target" and base? I'm trying to write a RAG formula for some survey results where agents were asked to rank skills from 1 to 5, and I understand how to apply this formula to all the 5s and the 1s, but if I wanted to assign the amber or orange color to all results between 2-4, how would I do this? I can follow your formula well enough to get it to show reds and greens but nothing in between
Hi try the following: KPI = IF([Number] >= 2,IF([Number] >5,"www.computertutoring.co.uk/downloads/rag-symbols/green-circle.gif","www.computertutoring.co.uk/downloads/rag-symbols/orange-circle.gif"),"www.computertutoring.co.uk/downloads/rag-symbols/red-circle.gif")
Hi, What if I have a RAG in excel already which I need to import in Power BI. How can it recognize that RAG buttons are already placed in excel? I tried to import it but when I placed the column with RAG, the number corresponds to the RAG color only appeared. I tried changing the data types but still wont show the RAG buttons. Might have missing something. Appreciate your advise.
Hi if the rag items are in a PowerPivot data model you should be able to import them. docs.microsoft.com/en-us/power-bi/transform-model/desktop-import-and-display-kpis However if it's the basic conditional formatting you're using in Excel then you might have to enter the formula in this tutorial.
@@computertutoring i'm actually using the icon set conditional formating in excel. The condition is actually tricky so I have to manually format the condition per country it does not depend on the numbers more of how long those figures has been in the pipeline. Ex. For France we have an alert since Q2 2021 even if the alert is 1 that is already a red. But if we have an alert on Q4 2021 or Q1 2022 that is considered as amber. Green if none or blank. I have done this in excel already but wanted to migrate it in power bi but it shows the number only not the rag button
@@computertutoring i did check powerpivot, seems like this can be the answer but not yet entirely sure. I need to test it does resolve my problem. Thank you for your time
Hi build up the if statement low to high I've used 10 5 and 0 but the logic is the same. =IF(risk>0,IF(risk>=5,IF(risk>=10,"Red","Amber"),"Green"),"Blank").. Hope this gives you so😀me ideas
@@computertutoring on your sample 0 will be Red, 5 will be Amber and 10 will be green? I tried doing this but the amber is not showing if the value is 1or 2 rather it shows green instead
@@idolsensei7 Hi This formula shows Red Green and Amber for me: KPI RAG = IF([Sales2]>=0, IF([Sales2]>=1, IF([Sales2]>=3,"www.computertutoring.co.uk/downloads/rag-symbols/green-circle.gif", "www.computertutoring.co.uk/downloads/rag-symbols/orange-circle.gif"), "www.computertutoring.co.uk/downloads/rag-symbols/red-circle.gif") ,"") Hope it works
