undefined

[akhassim]

I have a column called current phase. Values are true and false. I need true to be a tick and false to be blank. Please assist.

[ChiragGarg2512 · Accepted solution]

@akhassim Try this dax measure:

Measure 10 = IF(`VALUES('tableName'[Column]) = "True"`, UNICHAR(10003), BLANK()).

The expression might need changing but otherwise it should work.

Thank You

[Ritaf1983 · Accepted solution]

Hi @akhassim 

There are many options to achieve it.

My 2 suggestions:

First with dax

You can change the data type of this column to text.

And create a measure :

Phase =

if(max('Table'[current phase])="True","✅","")

Second with conditional formatting

Link to a sample file 

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

[ChiragGarg2512 · Accepted solution]

@akhassim Try this dax measure:

Measure 10 = IF(`VALUES('tableName'[Column]) = "True"`, UNICHAR(10003), BLANK()).

The expression might need changing but otherwise it should work.

Thank You