Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Dynamic format unstable behavior (bug) - chart vs matrix

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:

Fm_Zero =
var _sm = FLOOR(SUM(Data[hours_under_0]) * 60,1)  -- hours to minutes
return
IF(ISBLANK(_sm), BLANK(),
QUOTIENT(_sm, 60) & "h:" & MOD(_sm, 60))

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?
pbi_bug.png

Status: Investigating

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

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

Mitrey
Frequent Visitor

Hello, @v-xiaoyan-msft 

thanks for your answer.

This happens in both Desktop and Service.

Not sure that I managed to attach the file properly, this is my first time here.

 

Father_Frost_Short.pbix