Forum Discussion
Kudo CollectorDynamic Format Data Labels not working in charts
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
22 Replies
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?
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.
Hi is there an update on this bug fix?
iBusinessBIAnonymous
Any update?- iBusinessBI
Anonymous Any updates?
- amitchandak
Super User
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/
- iBusinessBI
Well, it doesn't work...
It does for matrix, but not for Data Labels in charts.
Have you seen the file I've attached?
SuhasiniMMicrosoft Employee
Hello,
I have followed the same link,but no luck.
Thanks and Regards
Suhasini G Metri
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.
- 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?
- iBusinessBI
Anonymous
Hi Liu, so do you see the bug?
- 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 RegardsSuhasini G Metri- SuhasiniM
Any update on the above error?
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
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.
- iBusinessBI
SuhasiniM Anonymous Any updates?
DimaMDSolution Sage
- iBusinessBI
I don't want a decimal place to be shown.
It is clearly a bug.
- EHA_SD
Advocate IV
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 ?
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.
