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

Manish

 

 

  • 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

5 Replies

    • 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.