Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
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.
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |