Formatting Year total to two decimals

Power BI Data Model
1

image
image.png1431×856 116 KB

I was able to format the monthly numbers to two decimal points - but not able to get the year total to format to two decimal points - any ideas how this can be done?

Thanks,

Dave…

2

What format do you have for that overall measure?

I think it should just adjust to whatever you have it formatted as.

As an alternative you could also place a format around the last part of the formula.

    FORMAT( [Actuals (,000)],
        FILTER( 'Financial Details', 'Financial Details'[Items] = CurrentItem ) ), "$0.00" ))

Something like this…

See if either of these options works.

3

Thanks, Sam - I formatted the overall measure and it worked perfectly!