Is RANK X dynamic? for example I calculate the top 10 nationalities of a population, then create a chart displaying the top 10 nationalities of the female population in 2016, will RANK X output readjust accordingly?
It seems to me that won't work. The top 10 limit should be set as a setting of the visual ideally.
I wanted to display TOP N values in my PBI graph but I have a little different scenario.
1st value for graph: I am grouping columns (lets say employee_name) and using count function with it.
2nd value for graph: District where he belongs.
I'm getting results as expected but now I want to filter TOP 10 but don't know how to do that.
I too strongly dislike the Pie Chart. Few's essay was a pleasure to read.
Nonetheless I have to commend the Pie Chart for one additional arcane application: the agenda for a 1-hr meeting. The similarity between a pie chart and the face of a clock lead to a quick and enjoyable appreciate of how the next hour will be spent. A small slice at the beginning can even be devoted to slandering the Pie Chart and recommending a 'Few' alternatives.
It's not so much about liking or disliking pie charts. Pie charts to serve a purpose and when used correctly, they can be of great value. Unfortunately, they are often used wrongly, i.e. with too many slices and too much bling, like 3D effects.
Your example of using a pie chart had me laugh out loud spontaneously. That is a brilliant use of a pie chart, especially when the meeting is scheduled for an hour. If the meeting takes more than an hour, I would even take exception to the notion that there's only one thing worse than a pie chart, and that's two pie charts.
But really, if the meeting is more than an hour, it would be a great visualization to show the agenda items in two pies. Plot the first 60 minutes in one pie and the remainder in another pie, which can be padded with empty minutes.
Then overlay the pie with the minute hand of a clock and show it as an animated chart that updates every minute.
Best pie chart ever!
@Sean Hi I have tried inserting this > Measure = RANKX(ALL(vwHMSCustPerfReport[ShipperConsigneeName]), CALCULATE(SUM(vwHMSCustPerfReport[Amount]))) There is no error, but it doesnt work. Did I use it wrongly?
Just to to the visual filters of the chart. Then add a filter of the leyend type Top N in this case set 10. You need also to add the By value parameter to order this top 10.
I hope it works.
Updating this thread as there is a solution now that probably came with the latest updates. In the Visual level filters, if you click on the drop down arrow of the group that you want to show top N of, click on the drop-down for "Filter type" and you should be able to see the choice "Top N".
With that selected, you are now able to show "Top Items" and input your value (1,2,3,4,5 ...10). Finally, pull in the column where you are calculating the value into "By value" and you should be able to quickly get what you need.