Forum Discussion
Dynamic Formatting issue
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 % i...
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.