Custom Conditional Formatting with Icons

[jean_valadez]

Hello - I am working on using custom conditional formatting icons for the table as follows:

STATUS                             ICONS

NOT STARTED	Red Diamond
IN PROGRESS	Yellow Triangle
IN REVIEW	Yellow Circle
CLEARING COMMENTS	Exclamation Point in a yellow circle
COMPLETED	Check mark in a green circle
BLOCKED	X in a Red Circle

I would like my symbol to display on the left of my already existing Status column. How would I go about creating these custom icons for my tasks status?

Thank you,

Jeanette

[Anonymous]

Hi @jean_valadez ,

I think you can use conditional formatting in table visual/matrix visual. 

Select [Status] column andapply setting to Icons.

Result is as below.

For reference:Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

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

[jean_valadez]

Hi Rico - Thanks for the feedback. That is what I expected the conditonal formatting to let me do however I am not sure if I need to change my Status data under the Column Tools ribbon to another data type. It is currently set as Text/string and I do not get the first COUNT option as you are seeing in your screenshot. Please see below for reference:

Thank you,

Jeanette