Forum Discussion

kokoro_1202's avatar
kokoro_1202
Icon for Helper I rankHelper I
5 years ago
Solved

add new column by conditional formatting

hi all,

is there a way to add new column by conditional formatting & not at the visual point?
Or via dax?

 

  • amitchandak's avatar
    amitchandak
    5 years ago

    kokoro_1202 , yes

    example. You can use if of switch

     

    Switch( True(),

    [column1] in {"a,","b"} ,"red",

    [column1] ="C", "blue"

    ,"green"

    )

3 Replies

  • kokoro_1202 , means you want to show color in table column values. I doubt that possible. Conditional formatting is visual-level operation.

    • kokoro_1202's avatar
      kokoro_1202
      Icon for Helper I rankHelper I

      amitchandak don't need the color, just the text. is that possible or with dax formula?

      Sorry, didn't state that earlier.

       

       

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User

        kokoro_1202 , yes

        example. You can use if of switch

         

        Switch( True(),

        [column1] in {"a,","b"} ,"red",

        [column1] ="C", "blue"

        ,"green"

        )