Forum Discussion

Jurgen1978's avatar
Jurgen1978
Regular Visitor
5 years ago
Solved

Sorting a visual based on a measure with numeric values and asterisk

Hi everyone, I'm having problems sorting for example a visual, based on a measure that consists of numeric values as well as Asterisk (values which we don't want to show because too small) Until now...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Jurgen1978 ,

     

    How about if you create a measure as below:

    Measure=if(outcome>10,outcome,blank())

    If it still doesnt work,could you pls provide some sample data for test?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

  • Jurgen1978's avatar
    Jurgen1978
    5 years ago

    Hi Kelly. Thank you for your reply. The formula works. However, Power BI won't show the categories with value Blank. For the moment I replaced Blank in your formula with 0. While sorting desc. the categories with value 0 are shown below the categories which have values >10

Jurgen1978's avatar
Jurgen1978
Regular Visitor
5 years ago

Thank you for your answer! However, actually the outcome is not necesarrily blank. All outcomes <10 are given an asterisk sign, which results in blank, in the visual. So the advanced filter "is not blank" doesn't work. Moreover I wouldn't want to hide them. I would want to show the categories, however I would want them to be situated below the categories tat do show values. 

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  Jurgen1978 ,

 

How about if you create a measure as below:

Measure=if(outcome>10,outcome,blank())

If it still doesnt work,could you pls provide some sample data for test?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

  • Jurgen1978's avatar
    Jurgen1978
    Regular Visitor
    5 years ago

    Hi Kelly. Thank you for your reply. The formula works. However, Power BI won't show the categories with value Blank. For the moment I replaced Blank in your formula with 0. While sorting desc. the categories with value 0 are shown below the categories which have values >10

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi  Jurgen1978 ,

       

      As tested here,it works fine.

       

      For decending,0 should below the values of >10,so what is the issue?

       

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!

      • Jurgen1978's avatar
        Jurgen1978
        Regular Visitor
        5 years ago

        Although the solution is not ideal, for the moment it works.