cancel
Showing results for
Did you mean:
Helper I

## Create a top/bottom10 filter that displays the top/bottom items

Hi,

I'm looking to create a bar graph that displays the top/bottom 10 items sorted on a metric (lets say impressions) based on a dropdown filter selection. Something like this:

Any help with this will be really appreciated!!

Thanks

Shubham

1 ACCEPTED SOLUTION
Community Support

Hi, @shubhy04

As mentioned by @lbendlin , visual filter pane would be a better choice if you dont want to calculate any measure.

You can check if these tutorials could help.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Community Support

Hi, @shubhy04

As mentioned by @lbendlin , visual filter pane would be a better choice if you dont want to calculate any measure.

You can check if these tutorials could help.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User III

Super User IV

@shubhy04 , Create two-measure which select top 10 or bottom 10

Top 10 City Rank = CALCULATE([Sales],TOPN(10,all(Geography[City]),[Sales],DESC),VALUES(Geography[City Id]))

Bottom 10 City Rank = CALCULATE([Sales],TOPN(10,all(Geography[City]),[Sales],ASC),VALUES(Geography[City Id]))

Create an independent table with Top 10 and Bottom 10 values and do like what is done in measure slicers

Proud to be a Super User!

Helper I

Hi @amitchandak , i tried but the very problem i'm facing is that i dont need to calculate any measure (in your example aggreagated [Sales] as a separate measure) since each record in my dataset is a unique record with a column containing metric value. I want to see the top/bottom 10 posts based on this column value and also work dynamically to handle any external filters.

Thanks

Shubham

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.