Forum Discussion

melina's avatar
melina
Helper IV
9 years ago

Color row based on date condition

Hi, Can i formatting the table in Report (desktop) and dashboard, for example in one table i want to change row colour based on date condition, for the pass date i want the table row became red,cu...
Show and Tell
melina's avatar
melina
Helper IV
9 years ago

How about using MDX?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi melina,

    Do you mean DAX? If so, we are not able to achieve your requirement using DAX.

    A workaround is to create a new column using the following DAX, and then create a bar chart to display SO number in different color.
    Column = IF(Table3[Closing Date]>=TODAY(),"Green","Red")



    Thanks,
    Lydia Zhang

    • melina's avatar
      melina
      Helper IV
      9 years ago

      Thanks for your answer

    • hassantariq's avatar
      hassantariq
      New Member
      9 years ago

      Can we do the same  with Table rows ? The complete row should be red or green based on this condition.

       


      Regards,

      Hassan Tariq