Formatting numbers to B, M, K dynamically based on values in bar chart

[Anonymous]

Hello All,

I am trying to get value lables in below picture in power BI bar chart, my Y-AXIS measure is EntryCount=Count(Table[EntryNumber]).
If my number value is in millions show it in millions , if like 0.4M show it as 400k like this 

Please help,
Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,
Thanks for his reply. His measure is available, but one thing I need to correct is that in this case, the y-axis accepts a numeric type and the format casts it to a text type, which is why the outright substitution is unsuccessful. The correct application is visualizations -> Format your visual ->Data lablesv -> Value, apply this measure to the filed box

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[bhanu_gautam]

@Anonymous , You can create a measure 

If you want to customize the display units further, you can use a DAX measure to format the values. 
FormattedEntryCount =
VAR EntryCountValue = [EntryCount]
RETURN
SWITCH(
TRUE(),
EntryCountValue >= 1000000, FORMAT(EntryCountValue / 1000000, "0.0M"),
EntryCountValue >= 1000, FORMAT(EntryCountValue / 1000, "0K"),
FORMAT(EntryCountValue, "0")
)

Use the Custom Measure:
Replace your Y-axis measure with the new FormattedEntryCount measure.

[Anonymous]

I cannot able to add above measure in Y-AXIS, when i am dragging it directly going and placing in Tooltips, 
why it's happening like this any idea?