Sort by Decrease sales or increase sales

[sebasjun]

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

[Vvelarde]

@sebasjun

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

 

Regards

Victor

[sebasjun]

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]

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]

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

[TomMartens]

Hey,

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

Regards

Tom

[sebasjun]

Hi!

Sorry

The link in one drive:

https://1drv.ms/u/s!AsSvKzm0ifH4y1JCgPPbH3TESoNi

Thanks