Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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.