Help! Top 5 and Others

[ScotchCat]

Help! I will need to create a pie chart that shows the top 5 by Rank (1-5) and group all the rest (Rank 6-9) into an 'Other' category.  I'm pretty new at this - be gentle!  Thanks in advance! 

My table is called CoolSports 

Here's the data in my table: 

CATEGORY	ROW_COUNT	RANK
WaterSki	812	1
SnowSki	727	2
Biking	699	3
Mountain_Bike	547	4
Swim	358	5
Hiking	210	6
Telemark	175	7
Walk	50	8
Jog	23	9

[ScotchCat]

I tried the suggested solution, it didn't work - back to square one. 

[mahoneypat · Accepted solution]

You can do this with the Charticulator visual.  See example below.  The key is to make a measure like the one below along with the Category and Row Count columns in your visual, and then Group By the new measure and make it a radial scaffold.

(3) Charticulator: Now a Power BI Custom Visual! (with Daniel Marsh-Patrick) - YouTube

Top5 =
VAR top5 =
    TOPN (
        5,
        ALLSELECTED ( CategoryRank[CATEGORY] ),
        CALCULATE ( SUM ( CategoryRank[ROW_COUNT] ) ), DESC
    )
VAR thiscategory =
    SELECTEDVALUE ( CategoryRank[CATEGORY] )
VAR result =
    IF ( thiscategory IN top5, thiscategory, "Others" )
RETURN
    result

Pat