Formatting cell values of a table added with table widget to dashboard

Question

I added a table widget and connected it with a table in a dashboard. I want to format select cell values. I'm think I could manage this with Arcade, similar to what's below. Is there a way to handle this table formatting in a dashboard? var bld = Concatenate(''+$feature.LT2_Difference+'') # Format where values are less than or equal to -1 var val = When($feature.LT2_Difference <= -1, bld, $feature.LT2_Difference); return{ LT2_Difference: { displayText : val, textColor: '', backgroundColor: '#e0e0e0', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' } }

JenniferAcunto · Accepted Answer

You can find the Advanced Formatting for tables under the Values tab. Each column will have its own section of the return statement.

ellipsol · Accepted Answer

Thank you, I misspoke and realize I was trying in Experience Builder, not a Dashboard. I got a minimum working example with your response, in a Dashboard.

var bgcolor = When($datapoint.diffVal <= -1, '#CC0000', '')
var tcolor = When($datapoint.diffVal <= -1, '#111', '')

return

return {
  cells: {
    LT2_Difference: {
      displayText : $datapoint.diffVal,
      textColor: tcolor,
      backgroundColor: bgcolor,
      textAlign: 'right',
      iconName: '',
      iconAlign: '',
      iconColor: '',
      iconOutlineColor: ''
    },
}
}