Forum Discussion
PVO3
5 years agoImpactful Individual
DAX Format EU numbers
Hello, I'm looking for a solution to format my numbers to EU standards in DAX. This is mainly concerning thousand seperators. Read a lot of articles about converting my numbers to text, then rep...
amitchandak
5 years agoSuper User
PVO3 , ideally speaking regional format should change it.
Try giving format under properties in data model view and try
for steps refer
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
- PVO35 years agoImpactful Individual
amitchandak thanks for your reply!
Unfortunatly I'm looking for a DAX solution. For instance to create a measure that displays both displays currency and whole numbers.
- Jorenvdl5 years agoFrequent Visitor
As far as I know this is not possible. We have created a work around for the currency by creating a column that contains the currency icon. Using a filter, dimension table and a measure with SELECTEDVALUE you can give the user the possibility to choose the currency of his preference.
I am not sure how to achieve this with the decimal character.