Data Labels and Formatting via calculation group

[Anonymous]

Hi everyone,

I stumbled across some weird behaviour concerning formatting via calculation items and data labels.

So I have a calculation group with two items

• "None" - applies nothing
  • Expression: SELECTEDMEASURE()
  • Format String Expression: SELECTEDMEASUREFORMATSTRING()
• "Formatted" - should format the number to millions with no decimal places:
  • Expression: SELECTEDMEASURE()
  • Format String Expression: "#,#0,,.M"

Now this calcualtion group does indeed work with e.g. tables but when I want to use this in data labels it does not work, instead it simply adds an "M" at the end of the value, without formatting the value:

Are data labels somehow calculated differently? Or could it simply be a bug because of the new features regarding dynamic data labels and such?

Perhaps someone here can shed some light!

Thank you 🙂

[some_bih · Accepted solution]

Hi @Anonymous check link from sqlbi https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/ 

[Anonymous]

Hi! Thanks for the tip! It seems that this is a bug in Power BI or sucht. Alberto on SLQ BI took a look at it.