Forum Discussion

Icon for Helper I rank

Helper 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...

Icon for Community Champion rank

Community Champion

8 years ago

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

Regards

Victor

sebasjun
Helper 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
  Solution 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.
  - sebasjun
    Helper I
    8 years ago
    Hello
    
    Thanks for tu reply, I think the formula is not ideal for my report.
    
    I'm implemented a SLOPE formula from the excel
    
    And now i Thinjk run correctly