Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table with 3 columns: technologies, summary and count where i display the total number of each summary split by technologies. Right now it displays them in order, which is good:
Now I want to display only the first 20 rows. When I go to filters panel and i select top N for summary and the value is the count column, it displays 22 instead of 20 and the values are not in the correct order:
After value 245 I should have 231, instead I get 199 and the order is not right. What can be the issue?
Solved! Go to Solution.
@audreygerred Thank you very much for your prompt reply and here allow me to share some of it.
When applying the first N filters, make sure you select the correct field for the filter. It should be set to filter the Summary column based on the Count value.
If there are duplicate values in the Count column, the first N filters may contain more rows than expected.
Ensure that no other filters or slicers affect the visual object. Other filters may affect the data displayed.
If these steps do not solve the problem, you may want to consider create a measure, for example:
rank count = RANKX(ALL('Table'), CALCULATE(SUM('Table'[count])),, DESC, Dense)
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@audreygerred Thank you very much for your prompt reply and here allow me to share some of it.
When applying the first N filters, make sure you select the correct field for the filter. It should be set to filter the Summary column based on the Count value.
If there are duplicate values in the Count column, the first N filters may contain more rows than expected.
Ensure that no other filters or slicers affect the visual object. Other filters may affect the data displayed.
If these steps do not solve the problem, you may want to consider create a measure, for example:
rank count = RANKX(ALL('Table'), CALCULATE(SUM('Table'[count])),, DESC, Dense)
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can you send screenshots of all filters for bothe scenarios (topN and not topN)?
Proud to be a Super User! | |
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
96 | |
94 | |
59 | |
45 | |
42 |