Dynamic Format Data Labels not working in charts

[iBusinessBI]

I've created a measure with dynamic format (April 2023 version)

It is working fine in matrix but when I put it in a chart (bar/line) - it is not working. (I try to change "Display Units" from "Auto" to "None" - still not good)

Am I missing something? Is it a bug? How do I report this?

Please help

Link to Power BI file:

https://1drv.ms/u/s!AoP_9ampPIT7gdI6F4F7SElNOFvkhA?e=tLwb1N

[1llucasll1]

Changing the display units in chart worked for me(1)
Solution source from documentation  (2) 

(1)

(2) Visuals have formatting options that may impact how the format string is displayed. If the formatting is showing unexpectedly in a visual, go to the visual Format options, search for Display units and change it from Auto to None.

[EHA_SD]

I am having a similar issue when trying to display time values (e.g. 9hr 37min 16sec, or 54min 23sec, or 00:30:59) using dynamic formatting. I have also tried selecting 'none' as the axis format.

[SuhasiniM]

Hello,did you got any solution for the dynamic number formatting ?

[spham1215]

I am encountering a similar error where the axis of a stacked column chart loses the dynamic formatting when a legend is applied to the visual. Is dynamic formatting not working properly?

[Anonymous]

Hi  @iBusinessBI ,

The PG team is already dealing with this problem. The specific repair time has not yet come out. The team is also stepping up the repair. If there is progress, I will update it as soon as possible.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[iBusinessBI]

@Anonymous Any updates?

[iBusinessBI]

@Anonymous 
Any update?

[katierose08]

Hi is there an update on this bug fix?

[DimaMD]

@iBusinessBI Hi, 

[iBusinessBI]

I don't want a decimal place to be shown. 
It is clearly a bug. 

[Anonymous]

Hi  @iBusinessBI ,

Sorry to reply to you only now.

I have reported the issue internally, if there is any progress, I will update here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[iBusinessBI]

@SuhasiniM @Anonymous  Any updates?

[iBusinessBI]

Thank you, @Anonymous 

What is the estimated fix date? We are working hard to correct the bug building custom override measures instead of using dynamic format.

[Anonymous]

Hi  @iBusinessBI ,

I opened it and it shows fine

You can set both "Y-axis -- Values -- Display units" and "Data labels -- Values -- Display units" to to None

This is the version number of my Power BI Desktop, are you up to date with Power BI Desktop, if not, you can update it in the following Link and then open it to see if Visual displays properly:

https://www.microsoft.com/en-us/download/confirmation.aspx?id=58494

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SuhasiniM]

Hi Team,

I am also facing same issue after using dynamic number format Data Lables are not working in y-axis,I have changed the Dispaly Units to None ,still its not working,

Dynamic Format:

VAR _locale =

    SELECTEDVALUE ( Locale[Locale] )

RETURN

    "'"

        & FORMAT (

            SELECTEDMEASURE (),"#,##0.00",_locale

        ) & "'"

Please help on this.

Thanks and Regards

Suhasini G Metri

[SuhasiniM]

Any update on the above error?

[iBusinessBI]

@Anonymous 

Hi Liu, so do you see the bug?

[iBusinessBI]

@Anonymous 

We have the same PBI version.

It does show fine in the chart, only in the Matrix.

For A:

In the Matrix it shows 20,000 K (Correct)

In the Chart it shows 20,000,000 K (Not Correct)

You can also see it in the snapshot you've made - in your snapshot it also shows incorrectly.
Please confirm that you see this bug.

[iBusinessBI]

@Anonymous 
Liu?
Can some in Microsoft team confirm it is a bug?

[amitchandak]

@iBusinessBI , Followed the code given in this blog from Microsoft and it worked for me. Scroll down on the page and try

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/