TOP 10 and evolution trough months

[PGAndrade]

Is it possible to do the following using Power BI: "Create a chart that shows the TOP 10 operators with the highest IGR in each month and demonstrate it's evolution trough the months". I've managed to do it using Excel but I don't have any idea how to do it using the Power BI.
I would appreciate if somenone could help me.

Data Source:

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

[jdbuchanan71]

Hello @PGAndrade ,

Are you looking for something like this?

I have uploaded your sample file with the new cacluations here: Data Source.pbix

[PGAndrade]

Sup @jdbuchanan71;
Yes it's kindda like that, but whenever we use a slicer by month it should display the top 10 for that month and also the evolution trough all the months, I'll send you the Excel file that has exactly what I need:

Excel File:
https://1drv.ms/x/s!Aj9NbSmhynhdjS69JFJVlvxeCKmv?e=ym3GBv

BTW thank you really much for the help ^^

[jdbuchanan71]

Hello @PGAndrade 

I'm not sure how to do what you are looking for.  I was not able to figure out a way to get the months on the chart to ignore the filter on the month while still having the measure understand that you want the top 10 for only the selected month.  

I put it together in a .pbix file and I'm hoping another user will be able to help us.

The sample file is loaded here Resolution IGR.pbix

And an image from your excel showing the ask.

[jdbuchanan71 · Accepted solution]

@PGAndrade  HA!  Got em.  

I needed to add a disconnected table to use as an anchor point for calcing the graph.

I have updated the saved file here. Resolution IGR.pbix.

The data source for the .pbix file is just your excel table so you can go into Edit Queries > Data Source Settings > Change Source and point the query to where ever you save the excel file.

Cheers!

[PGAndrade]

Ohh yeah @jdbuchanan71 , 
Thank you really much 😛