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
Icon for Community Support rankCommunity 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
    Icon for Community Support rankCommunity 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.