Forum Discussion
Help! Top 5 and Others
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 |
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
resultPat
2 Replies
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
resultPat
I tried the suggested solution, it didn't work - back to square one.
