Forum Discussion
Top N, others and null values
Hi, I am no PowerBI expert. I have read multiple topics on this issue and have been trying things out for hours, but I still haven't reach the desired outcome. I have created a test file, see...
Hi v-kelly-msft,
Thanks for your time!
I actually want a top 3 category with an extra "others" category. The "others" category contains the blank rows and the other rows which didn't make the top 3. So basically the totals will always be the same but the grouping will be different. See the result that I want below:
Current:
Product | Sales |
| 920 |
D | 890 |
C | 785 |
B | 760 |
E | 730 |
A | 705 |
Totals | 4790 |
New:
Product | Sales |
D | 890 |
C | 785 |
B | 760 |
others | 2355 |
Totals | 4790 |
Kind regards,
Rotjer
Can anyone help me with this problem?