Top 3 Minimum and Top 3Maximum values, how?

[bilingual]

Hi i am used to dynamic filter in Excel, but if i want to create a matrix table with the following values( Price per unit) based on the filter:

TOP 3 Maximum price per unit

TOP 3 Minimum price per unit

Is there an easy way to do so?

[ChiragGarg2512 · Accepted solution]

@bilingual , need to create 2 different matrix visual for top 3 and bottom 3 as only one top N filter can be applied to a visual at a time.

[bilingual]

Thanks a lot, couldn find it, if i want to create a filter, with TOP and BOTTOM 3 bottom, can you help me? - The values are based on a measure.

[ChiragGarg2512]

@bilingual Go to View Tab, there is an option for filters. Then in the filter pane click on the field which has to sorted for top 3 or bottom 3. Expand it and change Filter type to TOP N, select either top or Bottom and the number, also the value on which top/bottom N is being ranked.