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?

  • manishbeniwal's avatar
    manishbeniwal
    Frequent Visitor
    7 years ago

    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's avatar
      amback00
      New Member
      7 years ago

      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'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