thousand separator

2 Topics

Paginated Report: CSV export uses wrong thousands separator character with language 'de-CH'
Hi all We have many paginated reports on our Power BI Server and all are defined with the language 'de-CH': We have the problem that there is an incorrect thousands separator in the CSV file when exporting to CSV. Here is an example of an exported CSV file: This means that in the CSV export, the character 'Right Single Quotation Mark' (HEX E2 80 99) is used as a thousands separator. In Switzerland, however, we use the character HEX 27 (inverted comma) as a thousands separator. As a result, our customers have major problems using the CSV file. Please fix this bug. Thanks, regards Pierre
PierreC
4 years ago Place Report Server
1.3KViews
0likes
2Comments
Display of various number formats in text field (thousand separator, bytes to right of decimal)
I'm displaying values into a Matrix where the values can be either whole numbers, currency, percent or decimal. Everything is working correctly. However, I would like to make three improvements to how the various data types are displayed and am struggling to get it right. For my current process, I'm doing the following: STEP DESCRIPTION 1 Taking all the values (the various numbers whether they are a percent, currency, decimal or number) and placing them into a single column that is defined as type 'DECIMAL NUMBER'. 2 Creating a new column of type 'TEXT' and populating it as follows. [Value] is the value mentioned in step 1. = IF('Data Append'[Type]="Currency",FORMAT('Data Append'[Value],"Currency"), (IF('Data Append'[Type]="Percent",FORMAT('Data Append'[Value],"0.0%"), (IF('Data Append'[Type]="Deci",FORMAT('Data Append'[Value],"0.00"), FORMAT('Data Append'[Value],0)))))) At this point, the data is formatted as expected: Example of Currency: $20,000,000.00 Example of Number: 20000 Example of Decimal: .09 Example of Percent: 50% For my request, I'm trying to: Request Description 1 For the whole numbers, I would like to add thousand separators (Example: from '20000' to '20,000') 2 For the currency, I would like to remove the two digits after the decimal (Example: from '$20,000,000.00' to '$20,000,000') 3 For the currency, I would like to see if I can display this in thousands so it is not as large a number, and include a thousands separator. (Example: from '$20,000,000.00' to '$20,000k') For request 1 above, I have no idea on how to accomplish that other than logic to break each value down based on length and insert in commas. I'm really trying to avoid, so I thought I would ask if anyone knew of a magic solution (those exist, right?) For request 2 above, I havent been able to find an answer to this either. For request 3 above, to round it to thousands I was able to try the following. This works, but still leaves me with the currency not having the thousands separator. ValueFrmtK = VAR CurrResult = IF('Data Append'[Type]="Currency",ROUND('Data Append'[Value] / 1000, 0),1) RETURN SWITCH('Data Append'[Type], "Percent", FORMAT('Data Append'[Value],"0.0%"), "Decimal", FORMAT('Data Append'[Value],"0.00"), "Number", FORMAT('Data Append'[Value],0), "Currency", if(CurrResult = 0, BLANK(), "$" & CurrResult & "K"), "" ) Would anyone have any recommendation on how to handle the above three items? Thanks!
Solved
DarthTim
5 years ago Place DAX Commands and Tips
3KViews
1like
1Comment