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

manishbeniwal's avatar
manishbeniwal
Frequent Visitor
7 years ago

I want that number in table should be converted in unit like 27958 should comes as 28 not 28K after changing the display unit to "Thousands". I dont want to show "K" or "M" after display unit change.

and then i will chagne the number column heading (Number in Thousands) for reference.

Thanks

v-lili6-msft's avatar
v-lili6-msft
Community Support
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