Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Format string in Tabular Editor in Thousands

Hi ,   Can someone help me to figure out the format string ot use for the below : Current Format :  $8,255,064 Desired Format :  8,255 K   Thanks,   Deevs
Need Help
Tips and Tricks
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    It’s my pleasure to answer for you.

    You may need to modify you date type in your model ,then try this in tabular editor:

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Anonymous 

 

It’s my pleasure to answer for you.

You may need to modify you date type in your model ,then try this in tabular editor:

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

RobertSlattery's avatar
RobertSlattery
Responsive Resident
5 years ago

That's what I assumed but can't get it to work in March 2021 version

 

When I add the K at the end, the thousands format no longer works and I get the actual value, not in thousands.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, RobertSlattery 

     

    Try this: #,##0,.K.

     

    Best Regards

    Janey Guo

    • RobertSlattery's avatar
      RobertSlattery
      Responsive Resident
      5 years ago

      Hi Janey, thanks for the lightning response but, unfortunately, same result: 

      1,000,000 -> 1,000,000 K