Forum Discussion
custom format
Hi ! I would like to express all the values of my repport in $K . Quite easy in excel with the custom format with something like $#.##0,. How can I do the same in power bi ? Do I have to create calc...
v-qiuyu-msft, thanks ! I did use the calculated column and divided by 1000. Then I added an external legend saying that the numbers are in K€.
Hi fsim,
The thing you did is also get text data type instead of numeric values, which is the similar to my original post. So you are not able to sum those values.
Best Regards,
Qiuyun Yu
I did the calculation in the data modeling and it kept the value type. See I have the total
Hi fsim,
Get the point. You have added additional legend to indicate all values in a table are K€ format. But what I mean is displaying all values in table as $K format, then we are not able to sum totals. Hope you can understand know. :smileyhappy:
Best Regards,
Qiuyun Yu