Issue with Formating string

[Anonymous]

Hi!, I am using different measures in my report, but for some reasons this SWITCH() has problem, or more the logic is wrong.
For some reason, Power BI recognised my [Sales Amount] value as it should be bigger than 1,000,000, but in reality it is 331,289.
In the below you can find code, visualisation, and tooltip for this column that show bad result.

Thank you for any help 😄

[amitchandak · Accepted solution]

@Anonymous , for this selected measure, better to use field parameters

and for formatting use "Dynamic Format Strings" for each one

Field parameters
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw

Power BI Dynamic Format Strings for Measures| Format without converting to text: https://youtu.be/qHALucET7N8

[Anonymous]

Thank you @amitchandak for help!