Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Data Labels and Formatting via calculation group

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 🙂