I'm trying to format a measure such as below (the outcome is encircled in red). The problem with measures such as these, is that they have a possible text outcome (not any). Power BI therefore considers the date not to be whole numbers, but text. No problem, since that is why we have a text function called "Format", right? (I know there is a sorting issue with the Format function, however, this is not my concern right now, since I am only using this in a card visual at the moment). My problem is that I can't seem to get the thousand separator to become a dot.
My localization is Dutch, my display language is English. This means I normally see all decimals as commas and all thousand separators as dots. For regular Whole Number data columns, this happens just fine. The same goes for "normal" measures performing some type of aggregation (sum, count, etc), as long as they always result in a number and are thus formatted as whole numbers by Power BI (encircled in green).
According to the information I found, I need to enter a comma as a thousands separator and Power BI would need to use my localization settings to correct this to a dot. However, despite my regional settings being Dutch (both Windows 10 and Power BI), it keeps giving me a comma. When I try a Dot instead, I get a dot like expected, which behaves as the decimal sign.
Now of course I can just substitute the comma for a dot with the substitute function, which I have done, but this feels very much like a bug to me. Also, this easily becomes very tricky when you actually do need the decimals. The other thing is that this will result in incorrect data when someone with their regional settings set to English will open the report.
Thank you for your consideration,
p.s. I have seen many posts about format, I could not find one that covers this exact issue. If their is one, I'm sorry to have missed it. Feel free to remove my post in that case.