Forum Discussion
powerbiexpert22
Impactful Individual
Impactful IndividualData Labels and Y Axis - Dynamic Format String
i am using dynamic string for measures in my below shown bar chart, i am using below measure as example , i want to how data labels and Y axis values in thousands or millions with two decimal places , example 6,200,000 should appear as 6.20 M and 54,644 should appear as 54.64 K . I am using dynamic format string as shown below
you can try this
VAR SelectedMeasure = ABS([Measure]) RETURN SWITCH( TRUE(), SelectedMeasure < 1000, "#,0", SelectedMeasure < 1000000, "#,0,.0""K""", SelectedMeasure < 1000000000, "#,0,,.0""M""", "#,0,,,.0""B""" )pls see the attachment below
