Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |