formatting

Hi Mal_B,

We can’t format your columns to be same format as that(#,###_);[red](#,###);"-   ";@ and  #,###.00_);[red](#,###.00);"-     ";@) in Excel.

However, if you want to change the format of amount columns to currency format as other post, you don’t have to create additional column or measures. You can directly change the format under Modeling ribbon.

1. Click your column in Field panel, then change its format to Currency General as shown in the following screenshot.

2. Set Decimal places to 2 when you want the column to show as decimal format.

3. Create a table visual using your amount columns, you will be able to use continual formatting feature to set cell backgrounds.

Thanks,
Lydia Zhang