Forum Discussion

sebasjun's avatar
sebasjun
Icon for Helper I rankHelper I
8 years ago

Sort by Decrease sales or increase sales

Hello

 

I have question and is possible no have solution. 

 

I have a power bi with my sales from my customers. and i have created a calulated measure for a trend (Using this post) .  

 

But Is possible to find the top 5 best customer (INCREASE SALES) and find se worst 5 customer (DECREASE SALES) ¿?

 

I attached the file https://we.tl/DRIHGi8bz8  using diferent mesaures and the analytic trend 

 

Thanks

 

 

 

 

Need Help

6 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    8 years ago

    Hey,

     

    the link to your file doesn't work, maybe you can upload your file to onedrive or dropbox.

     

    Regards

    Tom

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    sebasjun

     

    Hi, You can add a visual level filter to show the TOP or Bottom 5.

     

     

     

    Regards

     

    Victor

     

    • sebasjun's avatar
      sebasjun
      Icon for Helper I rankHelper I
      8 years ago

      Hello!

       

      This is not the solution because if you choise for example the customer 668 is a decrement and the others 10 is increment.

       

      In the main context i need to find the 5 increment / decrement sales, is possible the trend formula is not correct

       

      Any Ideas?

      • v-xjiin-msft's avatar
        v-xjiin-msft
        Icon for Solution Sage rankSolution Sage
        8 years ago

        Hi sebasjun,

         

        First in your shared report, the customer 668 is a increment.

         

        And there're only 4 decrement in your report. How to get the 5 decrement sales?

         

         

        And what the logic of trend formula?

         

        Thanks,
        Xi Jin.