Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Losing conditional formating after using "Show items with no data"

Hey guys,   I am using conditional formating on a field to change the background color, in a table. It works great.   The problem is that I need to include a column in the table that might or no...
Need Help
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

This is an issue i've battled with myself several times. To my knowledge there is no way to do this yet.
Where there is no data there is no evaluation being made which furthermore means that there is nothing to format. 

If I'm wrong and there is a solution I would be very interested in seeing it as well! 🙂

Br,
J

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi tex628 , 

but the conditional rule does not deppend on the new column. It just depends on the column I calculated with the color (col4). 

Also, the fact that every time I slide the new column along the table, all the values after that will disapear...what is the explanation for this?

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Could you show the conditional rule formula you created?

     

    Best regards,
    Lionel Chen

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lionel-msft ,

       

      the conditional formating is as follows:

      Backgroud Color

      Format by Field Value

      Based on field: Color

      Summarization: First

       

      The formula for the field Color is:

      Color = switch(true(), firstnonblank(TABLE_1[requeststatus_value_id],"NA") = 1, "#0800",
      firstnonblank(TABLE_1[requeststatus_value_id],"NA") = 2, "#ECB548",
      firstnonblank(TABLE_1[requeststatus_value_id],"NA") = 3, "#FF0011",
      firstnonblank(TABLE_1[requeststatus_value_id],"NA") = 4, "#6797E3",
      firstnonblank(TABLE_1[requeststatus_value_id],"NA") = 5, "#C0C0C0",
      firstnonblank(TABLE_1[requeststatus_value_id],"NA") = 6, "#000000", "#456789" )
       
      TABLE_1 is the table for where I retrieve most of the columns  and everything works fine (including the formatting) and only when I include a column from TABLE_2 the problem appears.
      Not all records on TABLE_1 have a correspondence in TABLE_2, this is why I had to use "Show items with no data".
       
      (I am sorry but I do not know how to insert images here).
       
      Thanks