Forum Discussion

ErrorPL's avatar
ErrorPL
Frequent Visitor
9 years ago
Solved

Replacing number for Name, but keeping Conditional Formating of table

Hi,

For past 2Hour I am struggling with finding a solution for my case.

Basically, I want a table with two columns, Expected bin code and ST Status, but I want to replace numbers in cells with text corresponding to it (2 - Done, 1 - Not Done), but a twist is that I want to keep my custom column colour. So all [Done - 2] cells will be green and [Not Done - 1] to be red. Dream table represents what I want to achieve. My data set represents a table I have (and Name is pulled via a relationship with a table named Text for Number). From my understanding, I am not able to use conditional formatting in a way I want, but maybe there is a way or other method. I will be really glad for the help.

Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi ErrorPL,

     

    As you said it's not possible to conditional formatting with text only with number why dont you try to do it with a UNICHAR coding:

     

    Done = SWITCH ( TRUE (), Table1[VALID] = "OK", UNICHAR ( 10004 ), UNICHAR ( 10060 ) )

    This will give you the following result:

     

    Get more Unicode from unicode list.

     

    Regards,

    MFelix

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    9 years ago

    Hi ErrorPL,

     

    As you said it's not possible to conditional formatting with text only with number why dont you try to do it with a UNICHAR coding:

     

    Done = SWITCH ( TRUE (), Table1[VALID] = "OK", UNICHAR ( 10004 ), UNICHAR ( 10060 ) )

    This will give you the following result:

     

    Get more Unicode from unicode list.

     

    Regards,

    MFelix

    • ErrorPL's avatar
      ErrorPL
      Frequent Visitor
      9 years ago

      Hi MFelix,

      Thanks for your suggestion. I had a look, and it is okey, but not perfect.

       

      Do you know if it would be possible to hide number and just leave a cell coloured? I tried in text formatting, but the problem is I can hide one type ( by colouring text to the exact colour of cell), but then other is visible. If this will be possible instead of replacing a number I will be happy with it.

      Thank you!