Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table visual in my report that has the columns 'Name' and 'Rating'. The column 'Rating' will have values from 1-5. There will be duplicates so you can have multiple 1's, 2's, etc. When I apply the filter 'Top N' on my visual and filter on 'Rating' I choose 'Average' as that is the best I guess in this case? But when I then say I want to have the 'Top 8' it will show more then 8 when for example you have 4 times a '1', 3 times a '2' and 3 times a '3', it will then show 10 rows. Is there a way it only show 8 values in this case? (I understand why it happens as it can not determine which '3' rows to include/exclude but in my case it doesn't matter which one it takes)
Name | Rating |
Name 1 | 3 |
Name 2 | 1 |
Name 3 | 2 |
Name 4 | 1 |
Name 5 | 2 |
Name 6 | 3 |
Name 7 | 2 |
Name 8 | 1 |
Name 9 | 1 |
Name 10 | 3 |
Solved! Go to Solution.
pls try this
Proud to be a Super User!
pls try this
Proud to be a Super User!
Great, thanks!!!
you are welcome
Proud to be a Super User!
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |