Forum Discussion
changing the formating
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 ,
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/3227449I hope it helps.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
1 Reply
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/3227449I hope it helps.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.