cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vikkers
New Member

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

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

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

vyiruanmsft_0-1694406010170.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

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

vyiruanmsft_0-1694406010170.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks that has been a big help. 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.