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 calculated fields for every value column ? Or did I miss an option somewere ? thank you in advance
Fred
9 Replies
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.
Anonymous, 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 :-/
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
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
