This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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.