Forum Discussion

manishbeniwal's avatar
manishbeniwal
Frequent Visitor
7 years ago
Solved

Regarding Display unit format

Hi Team, Once we select Display unit as Thousands or Millions and other format. It bydefalt show "K" or "M" as per the unit. But is there a way we can remove this "K" or "M" from the number and it ...
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, manishbeniwal 

    If you could use a measure to get it.

    for example:

    Create a measure with conditional divide 1000, then use this measure

    Measure (Number in Thousands) = CALCULATE(SUM(Table1[Value]))/1000

    Result:

     

    Best Regards,

    Lin

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Your question is not clear.  What exact result are you expecting?