changing the formating

[Anonymous]

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

[Ritaf1983 · Accepted solution]

Hi @Anonymous ,
Your pictures are not completely visible, so I hope I understood you correctly.
Please see my answer in the linked discussion, with a sample file.
https://community.fabric.microsoft.com/t5/Desktop/How-to-dynamically-format-numbers-currency-and-abbreviation-K-M/m-p/3227449

I hope it helps.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.