Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dynamic Top N slicer works with table, not with bar chart
Seeing I cannot expose the real data, I will present similar and simple example
Lets say I have a sales table with 1k sales across 5 product categories.
Now on the dashboard I present the top N per table visual (sales id, amount, product category) using the following guideline:
1. Create TopN table using DAX: 5, 10,15
2. Create Rankx to ranks sales by amount
3. Create DisplayTopN measure
4. In table visual filter pane set DisplayTopN = 1
TopN dynamic slicer works on the table.
What does not work:
Bar chart displaying only Top N as in the table visual but as total sales per category. For example: top 5 product divided across categories and if slicer set to 15 than 15 product divided and sumed per category.
Instead bar chart picks on all sales despite it having also DisplayTopN = 1.
Please your help.
Thank you.
Solved! Go to Solution.
Thank you for the help. In the end I have solved it using an aggration measure, ranking measure and a display measure.
Thank you for the help. In the end I have solved it using an aggration measure, ranking measure and a display measure.
I will fix something. But for now, can you share an example of a dashboard with a dynamic Top N slicer filtering a bar chart? It should be a common requirement, but surprisingly not easy to find one conclusive approach.
No one wants your actual data. Share some dummy data, explain the question and show the expected result. Share data in a format that can be pasted in an MS Excel file.
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |