Createing a Slicer Top N

Hi Anonymous 
Take a look at the linked tutorials:

https://www.youtube.com/watch?v=xT9CLKNL-7c

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

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi Anonymous ,

The easiest way is to create a rank column and use the rank column as a slider slicer.

For example, the following is a ranking of sales by ID grouped by year.

Rank = RANKX(FILTER('Table',[Year]=EARLIER('Table'[Year])),[Sales],,DESC,Dense)

Set up the slicer as follows. Choose Less than or equal to under Slicer settings.

When you slide to 3, it means filter Top 3.

RANKX function (DAX) - DAX | Microsoft Learn

How to use RANKX in DAX (Part 1 of 3 - Calculated Columns) - RADACAD

RANKX on multiple columns with DAX and Power BI - SQLBI

Note: Measures can't be put into slicers. So you need to create calculated columns for ranking.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.