Forum Discussion
TOP 10 and evolution trough months
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:
Anonymous 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!
5 Replies
- jdbuchanan71
Super User
Hello Anonymous ,
Are you looking for something like this?
I have uploaded your sample file with the new cacluations here: Data Source.pbix
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 Anonymous
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.