Canadian French number formats: Commas instead of decimals, space for thousand separator

[neda_PowerBI]

I already researched the forum and the Solution was not clear.

I would like to display  my numbers as French / European format. 

So commas instead of decimals: 59.5% should be 59,5%.

And thousand separator should be a space: 10,000 should be 10 000.

I already reviewed the post How to format data numbers to Canadian French currency format?  but the solution is not clear to me.

I'm fairly new to PowerBI.

Thanks in advance

[splambo]

To display a space as a thousands separator, maybe you can apply this solution to your situation:

FORMAT(MAX(yourTableName[yourColumnName]), "### ### ### $")

If not, please give more details:
Which kind of visual are you using?
What is your intended result?
What does your data source look like?

Can you post a screenshot?

[neda_PowerBI]

Hi! I figured how to display a space as a thousand separator! But I still haven't figured how to display a decimal point as a comma! For example, 59.5% need to be displated as 59,5%!!

please help!

Thanks

[splambo]

Since you don't give details on your data or your expected outcome it's hard to give precise advice, but I can tell you that if you're using a pie chart, PowerBI won't allow you to format those numbers (incredible, I know!).

If you are able to use numbers in a way that can be formatted, for example using a Smart Narrative card, try this number formatting, or numerical data formatting option:

Measure Name = "Inside these quotes you can write text and mention that "& FORMAT(MAX(yourTableName[yourColumnName]), "#,0")&"% of solutions work at least some of the time."

[neda_PowerBI]

No it cannot be changed in data view.

[chonchar]

Hello,

I believe you can change it in data view: 

Or you can find a replace the "." and replace it with a "," if that doesn't solve the problem, but I do not belive that is the best practice. I am also pretty new. 

Best, 

Cam