Forum Discussion
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 🙂
Hi Anonymous check link from sqlbi https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/
2 Replies
- some_bih
Community Champion
Hi Anonymous check link from sqlbi https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/
- AnonymousNot applicable
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.