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

[Anonymous]

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

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

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.

video_How to Create Power BI TOP N Report (Variable TOP N Filter) 

video_How to Create Power BI TOP N Report (Power BI Top 10 / Top N Filter) 

https://www.youtube.com/watch?v=nVvlEHKr_0o 

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.

[lbendlin]

Teach your users how to use the filter pane. It gives you that functionality for free.

[amitchandak]

@Anonymous , 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

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

[Anonymous]

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