Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sort order problem: DAX formatting convert numbers to strings

Hi all!    I am applying a format in a DAX-expressions. To be more exact, i do several DAX's in a switch statement. See below. If i sort by these formatted values they are treated as text string, ...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi T_Fischer,

     

    Click Modeling-> change format to Percentage.

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi T_Fischer ,

 

You may try perdefined format string like below:

FORMAT( 12345.67, "General Number")  
FORMAT( 12345.67, "Currency")  
FORMAT( 12345.67, "Fixed")  
FORMAT( 12345.67, "Standard")  
FORMAT( 12345.67, "Percent")  
FORMAT( 12345.67, "Scientific")

Regards,

Jimmy Tao

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Jimmy,

     

    Thanks a lot for your input.

    It looked very promising but unfortunately it still converts numbers to a text string.

     

     

     

    Br, Torben

    • v-yuta-msft's avatar
      v-yuta-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi T_Fischer,

       

      Click Modeling-> change format to Percentage.

       

       

      Regards,

      Jimmy Tao