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 🙂
Dynamic Number Format In PBI Measure
I have division measure, which contains values some of them should be displayed as %, and the rest as numbers, formatting should be based on another values in another feild. for example if attribute=ABC then measure should be in percentage else should be shown in number. my organisation doesnt allow tabular editor, so please suggest a solution that doesnt contain tabular editor.
