CONDITIONAL FORMATTING BASED ON RAG

[Anonymous]

HI I have a table status value R 1 A 2 G 3 I need an output like Whenever the table is having a value R, the output should come as red icon, if A then output should come as Amber icon. TIA

[amitchandak]

@Anonymous 

Refer : https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

This one if want to create something custom

https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[lkalawski · Accepted solution]

Unfortunately, you cannot set icons for text values in Conditional formatting.

In this case, you need to create an additional StatusID column (number type), e.g. R-1, A-2, G-3 and set icons for the given status based on this column. Below screen:

_______

If I helped, please accept the solution and give kudos! 😀