custom format

[fsim]

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 calculated fields for every value column ? Or did I miss an option somewere ? thank you in advance

Fred

[Sean]

@fsim

Not sure you can do this in a table/matrix - except maybe with a slicer and a Parameter Table - that will basically divide by 1,000

However - how are you visualizing this data? If with charts look in the data labels options

Also look here at the Custom Numeric Formats available

https://msdn.microsoft.com/en-us/library/ee634206.aspx

[fsim]

@Sean, Exactly what I wanted, but unfortunately this option is unavailable in table/matrix 😕  

 May be the parameter Table ? I need to investigate that option. I never did that before 

Thank you anyway !

[v-qiuyu-msft]

Hi @fsim,

In a matrix or table visual, there is no OOTB feature for us to format numeric values as $K. In your scenario, you can create a calculated column to format those values as $K use Format() function temporarily. But please note, we are not able to sum column values as those values are strings. See:

In addition, for your requirement, I will report it as a feature request internally. Will keep you updated once I get any updates.

If you have any question, please feel free to ask.

Best Regards
Qiuyun Yu

[fsim]

@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€.

[v-qiuyu-msft]

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

[fsim]

I did the calculation in the data modeling and it kept the value type. See I have the total 

[v-qiuyu-msft]

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.

Best Regards,
Qiuyun Yu

[Seth_C_Bauer]

@fsim Are you referring to changing the format? You can do this by clicking on the data symbol, click on "modeling" on the very top bar, and highlight the column you want, select either the money symbol or click "format" -> Currency and select the currency you want, and the number of decimal places.

[fsim]

@Seth_C_Bauer, Thank you ! I din't even know data could be formated in the PBdesktop data view and not in the query editor.

It's half of the solution anyway. I can add the currency, but not the thousand 😕