Formatting Numbers in DAX

[ysherriff]

Hi BI Community,

Need quick,

Can someone tell me what is wrong with my syntax? I have a dynamic chart title and format both fixed and percent numbers. The % numbers is working but I can't for some reason get the fixed number to work. I want a "," to so seperate the thousands. In the below example, I want to show 1,585. 

Thanks for your help.

My formula is

"Top " & SELECTEDVALUE(TopNSelection[Value]) & " campaigns contributed " & Format(TopNSelection[Top N SUM], "#.#, which is " & FORMAT(TopCampaignPct,"#.#% of all campaigns in " &SELECTEDVALUE('Date'[Qtr-Yr]) ))

Thank you in advance

[PC2790]

Did you try the thousand comma separator in the formatting section of Measure tools in measure?

Outcome:

[ysherriff]

Thanks PC2790 but I am doing this via DAX. It is a dynamic chart.

I have reformatted it as below but it still not giving me the comma for the thousands.

[AlexisOlson · Accepted solution]

Instead of "#.#" with a period try "#,#" with a comma.

[ysherriff]

Thanks Alexis. It worked.

Much appreciated

[ysherriff]

Let me clarify, the formula is in text string so you can not format it in Measures.