How to apply icon conditional formatting on text fields

[Ronak_1]

I have one text field which have some score (1,2,3) and date (23-Dec,24-Jan) as below, I want to display icon for value 1, 2 & 3 and same text for remaining values. Is it possible?

Output

[Ronak_1]

Thanks @SamInogic for solution.
I have used alernating rows (white & grey) in my table repot. But will change it to all white.
Any idea if this can also be hanldle?

[SamInogic · Accepted solution]

Hi @Ronak_1 ,

We can add a Icon formatting by clicking on column name >> select Conditional Formatting option and click on Icons option as shown in the below screenshot,

 

This will open the dialog to set values-based conditions to display icons, where we need to add value conditions for 1, 2 and 3 with required icons as shown in the below screenshot,

 This will show the icons along with data as shown in below screenshot,

 In Power BI, Icon Formatting we have 3 options for displaying Icons that are icons left to the data, right to the data and Only icon without data in each cell. So, if you want only icons without 1, 2 ,3 value and other cell should display text as it is then we need to do a workaround by creating a Column to define font colour of text to be white in case values are 1, 2, 3.

DAX for column will be as follows,

DataColor = IF('Table'[B] = "1" || 'Table'[B] ="2" || 'Table'[B] = "3", "White","")

Now will use this colour column for font Color conditional formatting as shown below

The output will be as follows, 

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/