001- How to display data value if number greater then 999 then show in thousand and less then 1000 show in number

 Question-001- How to display data value if number greater then 999 then show in thousand and less then 1000 show in number.

below screenshot





click new measure below code:- Copy belowcode

new_stock = IF(CALCULATE(SUM('CUT _BASE_DATA'[Free Av Stock]))>999, FORMAT(DIVIDE(CALCULATE(SUM('CUT _BASE_DATA'[Free Av Stock])), 1000),"#,##0.0") & "K", CALCULATE(SUM('CUT _BASE_DATA'[Free Av Stock])))


Below step follow:--

Select chart and select a axis and y axis below screen shot































Step 2:--
Select Format visual >> visual >> Data Label >> Value >> Field  - Change Free stock to measure Select . Below screen shot.

































Above data>>filed  click down arror >>select measure new stock(mobile icon).

Last Step:- Data label  >> Value >> Display Units >>Custom 
Below screenshot



About Me

author Click here for Connect FB

Click here for Linkedin