Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have seen where others have created a new summary table of the ranked, grouped data in order to select the top N and group the remaining categories into an "Others" group. I want to avoid creating a separate table if possible. I would like to plot values in a line chart (over time) and want the legend to be the top N and "Others" categories.
Any help is greatly appreciated!
Solved! Go to Solution.
Hi @Anonymous
If you want to use slicer to select the dynamic number of N,you may create a seperate table.If you just want to get Top N and the N isn't a dynamic number,you may create a calculated column to group the table to 'Top N' and 'Others'.
Regards,
Cherie
Hi @Anonymous
If you want to use slicer to select the dynamic number of N,you may create a seperate table.If you just want to get Top N and the N isn't a dynamic number,you may create a calculated column to group the table to 'Top N' and 'Others'.
Regards,
Cherie
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |