Forum Discussion

akhassim's avatar
akhassim
New Member
2 years ago
Solved

undefined

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.

 

Need Help
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    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's avatar
    Ritaf1983
    2 years ago

    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.

     

2 Replies

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    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's avatar
    Ritaf1983
    Super User
    2 years ago

    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.