Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 % 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



Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.