Forum Discussion
RAG status
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
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
2 Replies
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
Thanks that has been a big help.
