Dynamic slicer top N

[lmduc1991]

Hi,

Is there anyway that we can create dynamic top N slicer to filter the visualization show only top N based on their values at the latest period of time. For example, we have table below. I want to have a dynamic slicer where we can put the topn value in. In this example, if I put 2 in the slicer, the visualization will only show category A and C from quarter to quarter (A and C have highest value in quarter 4). Is There anyway we can achieve this? I realize that we can use Top N in filter panel to achieve such result but it is not dynamic.

Category	Quarter	Count
A	4	5
B	4	3
C	4	4
A	3	2
B	3	4
C	3	5
A	2	1
B	2	10
C	2	1
A	1	3
B	1	5
C	1	8

[lmduc1991]

Hi, 

It is not what I expect. In the video, they rank based on Total. In my case, I only want to rankx category based on the values at the latest period. In the table above, I just want to rank value solely on Quarter 4 and from there, I just want to show only category have the highest value in Quarter 4 on visualization.

[selimovd]

Hey @lmduc1991 ,

check the following video:

Filter Top N Values with a Slicer in Power BI (youtube.com)

I think that's what you need.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic