cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vitexo87 Member
Member

Re: How to display only the top 10 values in a chart

@Sean

 

Thank you worked, if I want to apply an ascending or descending sort that extent as I do?

Super User
Super User

Re: How to display only the top 10 values in a chart

@vitexo87 Select the chart and then - click the 3 dots in top right corner of the chart...

Sort Chart.png

 

jesuisbenjamin Regular Visitor
Regular Visitor

Re: How to display only the top 10 values in a chart

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.

Re: How to display only the top 10 values in a chart

Hello Sean

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.

Abduvali Established Member
Established Member

Re: How to display only the top 10 values in a chart

@Sean Excellent tip... This actually works!!! Thanks

jtraverse Occasional Visitor
Occasional Visitor

Re: How to display only the top 10 values in a chart

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.  

teylyn Regular Visitor
Regular Visitor

Re: How to display only the top 10 values in a chart

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!

XiB Frequent Visitor
Frequent Visitor

Re: How to display only the top 10 values in a chart

@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? 

dardo Visitor
Visitor

Re: How to display only the top 10 values in a chart

Hi @vitexo87,

 

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.

 

 

Highlighted
chungchin Visitor
Visitor

Re: How to display only the top 10 values in a chart

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.