This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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.