RAG status

[Vikkers]

I'm new to Power BI. I'm trying to set-up a dashboard. one of the fields in the source data is for RAG status. the field has either R, A or G. Idealy I would like conditional formating with an icon. so that R is red, A is amber, G is green. I don't want a table, just the icon. any advise would be welcome. thanks

[Anonymous · Accepted solution]

Hi @Vikkers ,

I created a sample pbix file(see the attachment), please find the details in it.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

1. Create a measure as below

Conditional formatting = SWITCH ( SELECTEDVALUE ( 'Table'[RAG status] ), "R", 0, "A", 1, "G", 2 )

2. Create a table visual and only apply the field [RAG status] on it

3. Make conditional formatting on it

Best Regards

[Vikkers]

Thanks that has been a big help.