Hello All,
I have been working with dynamic formatting ( see the screen below )
I am filtering specific account of my account list in order to return different formating.
The account in % it returns "0.00" which is what i want
but for the other account I want to show in K. "#,##0,K".
The issue is that the numbers are not in thousand, the first line should be 115' 064 '753.
Thank you for your help
Hi @Anonymous ,
Please try below dax formula:
var cur_ac=SELECTEDVALUE('Table'[Account])
return
IF(CONTAINSSTRING(cur_ac,"%"),"0.00","#,##0,")
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please try below dax formula:
var cur_ac=SELECTEDVALUE('Table'[Account])
return
IF(CONTAINSSTRING(cur_ac,"%"),"0.00","#,##0,")Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
