Forum Discussion
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
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.
11 Replies
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.
You are a Legend it did work :). Really appreciate your help.
Is there a document somewhere I can refer to figure out such formats?
Thanks,
Deevs
Anonymous
https://docs.microsoft.com/power-bi/create-reports/desktop-custom-format-strings
Best Regards
Janey Guo
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.
Hi Anonymous
Rather than changing it in Editor, you could do it at the visual level.
However, if you want to do it in Editor, you can try to do the following steps:
- Create a new column, divide it by 1000
- Round up/down your new column
- Change the data type to text
- Concatenate the new column with " K"
If you want to do it in DAX, use the create a new column using the following formula:
- New Format = 'Table'[Value] /1000 & " K"
Hi darentengmfs
Thanks for that but i really don't want to create whole bunch of measures as I got 20 plus measures that I have to apply that.
I really need to figure out updating it in the Tabluar Editor.
Thanks,
Deevs
