Forum Discussion
Dynamic slicer top N
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 |
2 Replies
Hey Anonymous ,
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/DenSelimovicHi,
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.
