Forum Discussion
Sorting a visual based on a measure with numeric values and asterisk
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,
KellyDid I answer your question? Mark my post as a solution!
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 , One why is to hide blank is using the visual level filter. So you can is measure is not blank. Not sure if that can work for you
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.
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,
KellyDid I answer your question? Mark my post as a solution!
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
Hi Jurgen1978 ,
As tested here,it works fine.
For decending,0 should below the values of >10,so what is the issue?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!