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"

)

[Anonymous]

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:

[ChrisInTheUS]

I have the exact same issue. Is this still being investigated?

[ptv]

Hi, I have same problems trying to dynamically format the [Total Revenue] using DAX

When i checked my dataset, and tried:

1. switch data type from 1.2 (decimal) to integer: it doesnot work either.

2. i created a table to check [Total Revenue] at date granularity at day level, there are weird format either at some days

In conclusion, a mystery

[dgarrido]

Hi, this is a very annoying behaviour or bug in Power BI .. anyone has find solution or reached to conclusions? Same issue here. Any help would be very appreciated. Thank you in advance.

[GabbaWally]

I am experiencing exactly the same thing with totals labels in a column chart while the dynamic formatting for the same measure is working fine in a matrix visual. Is there any update on this yet? Did Microsoft ever look into this?

[fat_cat]

Same here. On the "line and stacked column chart", dynamic formatting of Total labels (the labels on top of the column) is not working properly. Some numbers have two decimals, some have none and this seems to be random. At the same time data labels (same measure, on the splits of the columns) are working fine.

[Josh_Boj]

Hello, This is a huge problem for us also. Makes it impossible to use Dynamic formatting, so what is the point?