Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
Got a couple of questions for something I'm trying to set up - but unfortunately hitting a bit of a wall as to whether it's possible.
Sample:
Table is of Category, Subcategory, Item, Ticket Count
Top N Filter Applied to Item (based on Ticket Count Value)
Desired Result:
Table is sorted by Top 10 Items, no other rows past the top 10 items should display.
Problem:
As shown in the image above; there are more than 10 rows. I suspect that these are as a result of the same item being present with a different Category or Subcategory; however I need to have all 3 listed in the table for the purposes of the report I'm making.
Is there some kind of measure that I can set up to rank these (which will update on the weekly basis that this report is required for) to filter out any additional rows past the top 10?
Thanks in advance!
Andy
Solved! Go to Solution.
Hi @AndyB
Please refer to the following:
How to Create Power BI TOP N Report (Power BI Top 10 / Top N Filter)
Dynamic Top N with what-if parameter
Feel free to ask me for any question.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AndyB
Please refer to the following:
How to Create Power BI TOP N Report (Power BI Top 10 / Top N Filter)
Dynamic Top N with what-if parameter
Feel free to ask me for any question.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I would just apply the Top 10 N to a different field?
use Top 10 Ticket ID under Category rather than filter?
I hope this hels.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |