Regarding Display unit format

[manishbeniwal]

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 should be in Thousands or Millions according to display unit selection.

Manish

[Ashish_Mathur]

Hi,

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

[manishbeniwal]

Once i select display unit "Thousand" then in my table i don't want to show "K" but the number unit should be in thousand conversion.

Regards

[amback00]

Try setting the "Display Unit" to "None". Then select the Field on the right-hand side, select "Modeling" at the top and change the decimal precision out to the number of places needed.

[manishbeniwal]

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 · Accepted solution]

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