DAX Formatting - Money

Hi nataliesmiy1357,

I would avoid using FORMAT() for this, because it converts the value to text and can cause issues in visuals.

The cleaner approach is to use a dynamic format string on the measure used in the chart.

For example, for your budget measure, keep the measure as numeric:

Travel Budget = SUM('Table'[Travel Budget])

Then set the Format string expression for that measure to:

IF(
    ABS([Travel Budget]) < 100000,
    "$#,0.0,K",
    "$#,0.0,,M"
)

This will show:

• $18,480 --> $18.5K

• $4,184,448 --> $4.2M

If you have separate measures for Budget, Q1F, and Actuals, apply the same type of dynamic format string to each measure.

Also check the visual formatting pane and set the data label Display units to None or avoid forcing it to Millions, otherwise Power BI may override the measure formatting and show small values as $0.0m .

Best regards,

Solutions Architect · Microsoft Fabric Specialist · Parchitect

💡 Did my response help you? Clicking Kudos is a small gesture that goes a long way, it encourages contributors and helps the community thrive!

✅ Did I answer your question? Please mark my post as a Solution, it helps others find the answer faster.