PBI Data Label not working properly

Hi everyone,

I am encountering a persistent issue regarding Dynamic Format Strings when used in conjunction with the "Total Labels" feature on a Stacked Column Chart.

The Scenario: I have a measure where I applied a Dynamic Format String to auto-scale the values (displaying "M" for millions, "K" for thousands, etc.).

Here is the DAX logic I am using for the Format String:

VAR CurrentValue = SELECTEDMEASURE()
RETURN
SWITCH( TRUE(),
    ABS(CurrentValue) >= 1000000, "#,0,,.0 M",  -- Format for Millions
    ABS(CurrentValue) >= 1000, "#,0,.0 K",      -- Format for Thousands
    "#,0"                                       -- Format for standard numbers
)

The Problem: The formatting works perfectly for the individual segments within the stack. However, it fails inconsistent on the Total Labels at the top of the bars.

In some cases, even though the total sum of the stack is clearly above 1 Million (e.g., ~13 Million), the Total Label applies the nothing. As below for 2025 it should be 128M but not working properly.

I have to use this dynamic Format because my data is having wide range. As you understand from screenshot some year can be 150x times higher than others. If I use auto scale then I'm unable to see low values and i need to increase decimal values and it causes overlapping in the chart
Here it is an example for auto scale usage. I'm having lots of 0M values which tells meaningless words for me.

any idea/comment on that ?