topic Re: RAG status in Developer

RAG status

Vikkers — Fri, 08 Sep 2023 11:09:31 GMT

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

Re: RAG status

Anonymous — Mon, 11 Sep 2023 04:27:48 GMT

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

Re: RAG status

Vikkers — Wed, 13 Sep 2023 12:58:01 GMT

Thanks that has been a big help.