Using Arcade expressions to format specific values in Dashboard table field

JimMiller3

I've been working from both of these helpful posts about using Arcade to format values and cells in dashboard tables.

I've been able to do some things, such as formatting numbers and percentages. But I haven't been able to figure out how to bold specific values in a column and, for other values, change textAlign from left to center.

I can use displayText to make all values bold, or textAlign to make all values center aligned. My goal, though, is to make those changes for just certain values in the column.

Below is my desired output for the "Revenue Source" field. Thank you for any suggestions.

Revenue Source

Personal Income

Withholding

Other Pmts

Refunds

Corporation

Estimated Pmts

Other Pmts

All Other Revenue

Insurance

Tobacco

Other

 

JenniferAcunto

You need to have your arcade statement return HTML that does your desired formatting. 

var bld = Concatenate('<strong>'+$datapoint.COUNTRY+'</strong>')

var lft = Concatenate('<div style="text-align: center;">' +$datapoint.COUNTRY+ '</div>')

var blft = Concatenate('<div style="text-align: center;"><strong>' +$datapoint.COUNTRY+ '</strong></div>')

var ctry = When($datapoint.COUNTRY == 'Cameroon', bld, $datapoint.COUNTRY == 'Angola', lft, $datapoint.COUNTRY == 'Ethiopia', blft,$datapoint.COUNTRY )

return {
  cells: {
    ADMIN1: {
      displayText : $datapoint.ADMIN1,
      textColor: '',
      backgroundColor: '',
      textAlign: 'left',
      iconName: '',
      iconAlign: '',
      iconColor: '',
      iconOutlineColor: ''
    },
		
    ADMIN2: {
      displayText : $datapoint.ADMIN2,
      textColor: '',
      backgroundColor: '',
      textAlign: 'left',
      iconName: '',
      iconAlign: '',
      iconColor: '',
      iconOutlineColor: ''
    },
		
    COUNTRY: {
      displayText : ctry,
      textColor: '',
      backgroundColor: '',
      textAlign: 'left',
      iconName: '',
      iconAlign: '',
      iconColor: '',
      iconOutlineColor: ''
    },
		
  }
}