Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Dynamic Format String not formatting all numbers in column charts

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:

peterg0417_0-1690392489429.png

 

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"
)
Status: Investigating
Comments
Anonymous
Not applicable

Hi @peterg0417 ,

 

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

vxiaoyanmsft_0-1690536908899.png

 

 

 

Best regards.
Community Support Team_Caitlyn

 

peterg0417
Helper III

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
Helper III

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:

peterg0417_1-1692815649073.png

 

ChrisInTheUS
Regular Visitor

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

ptv
New Member

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
Regular Visitor
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
Regular Visitor
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
Advocate III
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
Advocate I
Hello, This is a huge problem for us also. Makes it impossible to use Dynamic formatting, so what is the point?