Dynamic Format String not formatting all numbers in column charts

[peterg0417]

Not sure if this is an issue others have experienced, but the dynamic format string is giving me problems in a very specific case. This seems to only be happening in a column/bar chart, when I have Total labels enabled, and a column in the "Legend" section.

See below:

I can share a PBIX file if necessary, but I will need a bit of time to remove any identifiable references (the actual data set itself has already been masked).

This is what my custom format string looks like:

SWITCH (

    TRUE (),

    SELECTEDMEASURE () < 1000, "$#,##0",

    SELECTEDMEASURE () < 1000000, "$#,##0,.0K",

    SELECTEDMEASURE() < 1000000000, "$#,##0,,.0M",

    "$#,##0,,,.0B"

)

[v-xiaoyan-msft]

Hi @peterg0417 ,

I made a simple test that you can try change  values to none.

Best regards.
Community Support Team_Caitlyn

[peterg0417]

I already changed the "Display units" initially and it didn't work.

Please note that this happens  for "Total labels" when a dimension data field is in the "Legend" section. Not "Data labels"

[peterg0417]

Is there any progress on this issue? I tried another data set to see if maybe it's my actual data that is causing this issue, but it's happening with a sample dataset as well.

See screenshot: