How to make my display units and sorting order also change according to field parameter?

[afaro]

I have two measures in my field parameter A and B. 

A and B both have widely different ranges of data. When I switch from A (data less than 100) to B (data in thousands), the display units still remains the same which doesn't work well for me. How can I set default display units for A and B so as to not skew the data labels numbers. 

I also want to set a default sorting order when switching. The sort order resets everytime I seem to switch from A to B and vice versa. 

[Anonymous · Accepted solution]

HI @afaro,

#1, Perhaps you can try to use field format string to setting display format:

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
#2, You can take a look a the following blog to know how to use custom table to apply field sort order:

Custom Sorting in Power BI 

Regards,

Xiaoxin Sheng