Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello, I have noticed a very weird results of dynamic formatting and consider this a bug to be fixed.
Zero - just a plain sum of a cloumn that contains number of hours in decimal format (like 3.5)
Fm_Zero - converts it to a more convinient format 3.5 -> 3h:30 with the following dax:
It works just fine for the matrix but if this code is used as a dynamic format string it htrows error if the nymber of hours ends with 0.
This is marked by red and green. It mulitplies the number by ~11 and rounds it.
Also, the axis got an extra "4" in the beginning - but this changes sporadically, it might also divide all the numbers by 10.
Checked with ROUNDDOWN and other similar functions as well as giving dynamic format throough calculation groups - always same result.
What do you think?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Mitrey ,
Does this issue occur in Power BI Services or Power BI Desktop?
Can you provide detailed version information and a sample pbix (Please be careful not to include sensitive information) so we can reproduce the issue?
Thanks in advance!
Best regards.
Community Support Team_Caitlyn